Discussion Locked
Round Up Deximal Places Nearest to 5 ?
0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
How to round up deximal places when i do the calculation using the union query. Although i have set the format property, but when it is union query it will not follow what we had set.
Example:0.833333 + 1.33333, union query will sum up as 2.17 when i set the deximal point property to "Fixed" in report.But if we manually calculate, I just want 2 deximal places, i.e 0.83 + 1.33 = 2.16. So how?