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?

1 reply

by sgt_shultz

sounds like you do *not* want rounding. so instead why don't you just truncate after second decimal. put results in variable, maybe manipulate as string to cut after 2 places right of period?

This discussion is closed to new replies.