Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rounding Up...

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.

1 Solution

Accepted Solutions
MK_QSL
MVP

7 Replies
MK_QSL
MVP

You can use CEIL Function...

CEIL(0.35,1)

ThornOfCrowns
Specialist II

Use CEIL(number)

Not applicable
Author

HI ,

You can choose CEIL() ,Rounding.png

PFA

Not applicable
Author

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
MVP

CEIL(SUM(FTE),1)

Not applicable
Author

Thanks Manish! This is just what I wanted.

Regards, Mike.

MK_QSL
MVP

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 .....!!