Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Rounding Decimal Values

dkma
8 - Asteroid

How to round decimals in the below scenario..

 

 

1..> if the number is 1.5 and above it should be rounded to fixed 2

2...> if the number is below 1.5 then itshould be  rounded to flat 1

 

please help 🙂

 

 

many many thanks in advance. 

1 REPLY 1
atcodedog05
22 - Nova
22 - Nova

Hi @dkma 

 

You can use round function in the formula tool like below

 

Round([Field1], 1)

 

Workflow:

atcodedog05_0-1635762453618.png

 

Hope this helps : )

Labels