Round Up to the Next Hundred-Value

[Cfdiaz2103]

Hi Everyone!

I've got some data to transform. What I need to do is something similar to the Excel Function "ROUNDUP", but the thing is that every value should be rounded to next hundred-value.

This is a sample of the original data:

29124

35480

126

90589

231

1400

891

And now, here is the desired result:

29200

35500

200

90600

300

1400

900

I'd appreciate any kind of support.

[terry10]

Rounding up can be done with the ceiling function. To round up to 100's you can use this formula. (workflow attached)

CEIL([Data]/100)*100