Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Rounding Up to Nearest Integer or Nearest multiple of 10

rushabh_shah
8 - Asteroid

Hi Team,

 

I am performing some mathematical operation on my data and i want the final output to be rounded up to nearest integer or nearest multiple of 10. Im using this formula Round(([Tickets]/[Trans_Count]),0) and keeping data type as Double. But its giving me Null output. Can you help?

 

Regards,

Rushabh

1 REPLY 1
jdunkerley79
ACE Emeritus
ACE Emeritus

The Round function in Alteryx takes the multiplier. So to round to nearest integer you need:

Round(([Tickets]/[Trans_Count]),1)

If you want nearest 10 replace ,1 with ,10.

 

If you want to round up then use the ceil function. So to round up to next multiple of 10:

Ceil(([Tickets]/[Trans_Count])/10)*10

 

I did a blog on various roundings a while ago: https://jdunkerley.co.uk/2015/07/29/rounding-calculations-in-tableau-and-excel-and-alteryx/

Labels