Round up

[tan_chungkam]

Hi Qlikers,

I am looking for special round up method.

Whenever the number more than itself 0.001, then it should be round up to integer number.

For example:

1.01 should round up to 2

2.01 should round up to 3

4.001 should round up to 5

[marcus_sommer · Accepted solution]

This could be done with ceil() and an appropriate condition maybe just simple if-loops or maybe also with something like this:

pick(match(sign(FIELD), -1, 0, 1), floor(FIELD), FIELD, ceil(FIELD))

- Marcus

[tan_chungkam]

@marcus_sommer ,

Thanks for your suggestion.

It works perfectly.