Rounding Down

Question

Hi All,

I have got a pretty unique requirement for rounding numbers. I want the result as 7 if my output is 7.5 and 8 if the output is more than 7.5

Ex:

7.5 = 7

7.6 = 8

Is there any workaround for this.

Thanks in advance.

atcodedog05 · Accepted Answer

Hi @hemant86

Use formula

Round([Field1]-0.1, 1)

Workflow:

Hope this helps : )

hemant86 · Accepted Answer

Thanks @atcodedog05 That was amazing. That's way more simple than I thought. 🙂 Two thumbs Up to You!