Rounding price to the nearest 0.09 cent

[D3K]

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!

[Greg_Deckler · Accepted 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]

@Greg_Deckler Great! It works like a charm! Thank you