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
Solved! Go to 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/