Round off

[SiddeshDhruva]

Hi, I am looking for a similar solution but in a different output, i want to split my data as below 

1, Decimal value

2, Scenario 1 - Nearest "0"

3, Scenario 2 - Nearest "10"

4, Scenario 3 - Nearest "100"

below is the example:

Spend number	Decimal Value	Scenario 1(Nearest "0")	Scenario 2, Nearest 10	Scenario 3, Nearest 100
141.34	0.34	141	140	100

please suggest

Thank you!

[atcodedog05]

Hi @SiddeshDhruva 

Here is how you can do it. By using round() function.

Hope this helps 🙂

[SiddeshDhruva]

Thank you! it worked, however for nearest 10 section, i want the formula to round down to near 10, ex: if the spend is 117 it should round down to 110 instead 120, is there any tweak in the formula?

[atcodedog05 · Accepted solution]

Hi @SiddeshDhruva 

Here is how you can do. I am dividing it by 10 finding the lower bound decimal of the value and the multiply by 10. Same strategy for 100.

Workflow:

Hope this helps 🙂

[SiddeshDhruva]

awesome:) exactly the same I wanted, thanks a ton:)