Rounding Up...

[#1]

Hi All,

I have data which details FTE (full time equivalent) which I would like to be able to round up to FPE (full person equivalent) within QlikView expressions.

I am aware there is the "=(round(SUM(FTE))" function and I have tried a variety of alternatives [=(round(SUM(FTE),0)], but this doesn't help to round up lower figures such as 0.33 or 0.25 UP to the nearest 1 which is what I am hoping to achieve with the dataset I have.

Does anyone out there know how this can be done.  If so, could you help me please?

Thanks in anticipation and regards, Mike.

[MK_QSL]

You can use CEIL Function...

CEIL(0.35,1)

[ThornOfCrowns]

Use CEIL(number)

[#4]

HI ,

You can choose CEIL() ,

PFA

[#5]

Hi guys,

Many thanks for your responses. 

My only query is, and just out of curiosity, if I wanted to keep the 'SUM(FTE)' principle within the context of the expression principle would CEIL / FLOOR be able to accommodate this?

E.G. =CEIL(sum(FTE),0.35,1) - would this work?

If not, how can I resolve this whilst keeping the SUM(FTE) in place as this is a crucial part of what I am trying to achieve.

Thanks and regards, Mike.

[MK_QSL · Accepted solution]

CEIL(SUM(FTE),1)

[#7]

Thanks Manish! This is just what I wanted.

Regards, Mike.

[MK_QSL]

Dear Michael,

Glad that my answer helps you.

Can you close the thread by selecting Correct Answer so that others can also get benefit of this?

Thanks .....!!