Compensation- rounding of fields to nearest 5 cent

[siyi_csy]

Hi Experts,

Would like to know if rounding of Money fields to nearest 5 cents is possible in SF Compensation?

We saw a KBA "Dates and Roundings in Compensation" and it mentioned that below formula can be used for rounding to nearest 10,100 etc.

Rounding to nearest 10: round(‘halfUp’,round(‘halfUp’,lumpSum)/10)*10
Rounding to nearest 100: round(‘halfUp’,round(‘halfUp’,lumpSum)/100)*100

However,when using the same formula for rounding to nearest 5 cents, it only rounded up to the nearest whole number [i.e: round(‘halfUp’,round(‘halfUp’,lumpSum)/0.05)*0.05]

Thank you!

[Former Member · Accepted solution]

try

round('halfUp',lumpSum*20)/20