Rounding Up to Nearest Integer or Nearest multiple of 10

[rushabh_shah]

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

[jdunkerley79 · Accepted solution]

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/