Hi,
I would like to round up the number and only keep to the nearest thousand for formatting purposes.
For example,
19599 should be 20000
33801 should be 34000
62499 should be 63000
1100 should be 2000
78999 should be 79000
all the number should be round up to thousand formatting.
I found there is function called round, but in Alteryx, this one is only for the nearest, not always round up.
Could anyone offer some ideas?
Thank you.
Solved! Go to Solution.
Spoke too soon, my logic was incorrect. Will rework.
@jdunkerley79 is correct. I was way overthinking the problem.
Thank you so much. It works well.
Thank you, you answer is also helpful, give me some ideas.
CEIL?