cancel
Showing results for 
Search instead for 
Did you mean: 

Exchange Rate in Crystal Report Rounds Down to Incorrect Value

helen_jim
Participant
0 Kudos
128

Dear Expert,

I am seeking assistance in resolving a number formatting issue within a Crystal Report.

The exchange rate displayed for marketing documents requires precision to six decimal places. However, despite inputting an exchange rate of 1.467750, the value presented within the Crystal Report is rounded down to 1.000000.

Attached, please find the field format of 'DocRate' in the Crystal Report for your reference.

Your expertise in addressing this discrepancy would be greatly appreciated.

Regards,

Helen Jimuntitled1.jpg

View Entire Topic
Abdul
Active Contributor
0 Kudos

It depends upon the decimals settings in general setting, have you allowed SAP to save 6 decimals? if yes please check the data stored in DB.

if DB has 6 decimals then simply convert it to text and crystal report will no round it.