The original setting interest-related column in this report is as follows:
The value of interest-related column's show 5 decimal places:
But the foregoing report does not meet user's requirement. The digits to the right of the decimal point in a number determined by the data. If the value is 0.55000, show 0.55; if the value is 0.62690, show 0.6269. The correct report is as following:
Solution
Use custom format instead. The configuration is as bellows:
No comments:
Post a Comment