Question

output in excel value is "0" instead of actual value 4,36,334.00 in amount field

  • 26 July 2021
  • 3 replies
  • 96 views
R
Rank
Badge +2
My system region settings 
IFS region settings
 

When i output data to excel  from payroll history overview screen for the field " amount" having more than 6 digits ---in excel amount field is displaying as zero "0"....i need amount value field to be displayed same as front end and with comma separated value. Any solution ?

This topic has been closed for comments

3 replies

Shardha Weeratunga
Rank
Userlevel 5
Badge +6

Hi @Roshini,

How did you export your data to excel?

I tried a similar action, and it worked for me. Please try to export into excel by actins described in the below image, follow from steps 1 to 3.

 

 

ShaR
R
Rank
Badge +2

Thank you shardha, 
But I already tried same way to output data , but it doesn’t work.

Shardha Weeratunga
Rank
Userlevel 5
Badge +6

Please try below options:

  1. Try the same in a different PC.
  2. Export the selected records using custom export option, in Output window, into csv. Open the csv file using Notepad and see whether the numbers with more than 6 digits are there.
ShaR
Terms & ConditionsCookie settings