community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Round Up

Asteroid

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.

Alteryx Certified Partner
Alteryx Certified Partner

Spoke too soon, my logic was incorrect. Will rework.

Highlighted

@michael_treadwell:

Unless am missing something couldnt you use:

 

CEIL([Field1] / 1000) * 1000
Alteryx Certified Partner
Alteryx Certified Partner

@jdunkerley79 is correct. I was way overthinking the problem.

Asteroid

Thank you so much. It works well. 

Asteroid

Thank you, you answer is also helpful, give me some ideas.

 

 

Labels