Decimal Format For Display
Posted: Thu Aug 06, 2020 5:58 am
Hi,Supports,
I have used a Sum function in my report,but the display of the reposrts is not correct. The total value is not same as the summary of every details .
For example,the correct value is 24513469.44 , but the display value is 24513469.44000001.
I would like to format the display values ,but i cannot find function to format the value which is match my requirement.
for example,I would like to keep 6 digits,123456789.123000001 == > 123456789.123,but not 123456789.123000
Could you give me some suggestions or how to resolve this issue.
I have used a Sum function in my report,but the display of the reposrts is not correct. The total value is not same as the summary of every details .
For example,the correct value is 24513469.44 , but the display value is 24513469.44000001.
I would like to format the display values ,but i cannot find function to format the value which is match my requirement.
for example,I would like to keep 6 digits,123456789.123000001 == > 123456789.123,but not 123456789.123000
Could you give me some suggestions or how to resolve this issue.