Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey everyone!
Hope to find a solution here.
I need to round a new counted price up to the nearest 0.09 cent.
For example:
23.47 -> 23.49
6.06 - > 6.09
15.32 -> 15.39
but
14.00 -> 13.99
Tried to use different variations of ROUND, CEILING, MROUND etc, but it doesn't work and I think I'm doing something wrong
Any help will be highly appreciated
Thanks a lot!
Solved! Go to Solution.
@D3K How about this?
Column =
VAR __Trunc = TRUNC([Column1])
VAR __Decimal = [Column1] - __Trunc
VAR __TensDecimal = TRUNC(__Decimal*10)
VAR __OnesDecimal = 9
RETURN
IF(__Decimal = 0, __Trunc - .01,__Trunc + __TensDecimal/10 + __OnesDecimal/100)
@D3K How about this?
Column =
VAR __Trunc = TRUNC([Column1])
VAR __Decimal = [Column1] - __Trunc
VAR __TensDecimal = TRUNC(__Decimal*10)
VAR __OnesDecimal = 9
RETURN
IF(__Decimal = 0, __Trunc - .01,__Trunc + __TensDecimal/10 + __OnesDecimal/100)
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |