Issues with Round function

jzink1211
jzink1211
edited February 2023 in Modeling
Screenshot 2023-02-09 at 10.05.33 AM.png

I've noticed an issue with the Round function while going through my L2 again. None of the available parameters seem to make it possible to get an accurate whole number rounded up.



In this example, I want the total (237.9) to be 238, not 240.

Best Answer

Answers

  • AjayM
    AjayM
    edited February 2023

    Hi @jzink1211 ,

    It's not an issue actually. The round function appears working fine at week level, as you can see 60 for 59.47. It's the TIME SUMMARY setting that's making a sum of week level values (Four 60s) and giving us 240 at month level. For your expectation of 238, you should be setting the time summary to FORMULA.

    Glad you figured that out.

    Cheers!

Categories