We have a formula where we calculate a daily rate down to the 6th decimal place. A precision calculation.

For example:

1000 * 12 / 365 = 32.876712

Despite trying many alternatives, I can not figure out how to get this number, the result is always rounded to 2 decimal places. Like so...

1000 * 12 / 365 = 32.900000

I have the result going to a decimal field with 6 decimal places. But it still shows up as 32.90.

I tried the round function..still 32.90. I have also tried toDecimal function too.

(1000 * 12 / 365).toRound(6)

Here's where the rounding problem surfaces. Our billing wants to collect $328.77 but Zoho states $329.00. That's a difference of $.23.

10 days * 32.876712 = 328.77

10 days * 32.900000 = 329.00

Thank you to whoever can help me solve this equation.