Rounding Up 0 digit Issue

[Pragna]

Hi All,

I am having an issue with the value that is not rounding up to 0 digits. Below is the test case that I am trying to execute.

Load - 6.42847509880085

Headcount - 11

Assumed Production - 1

Formula used for Assumed Production in excel :

=IFERROR(ROUNDUP(IFERROR((ROUND([@Load],0)/VLOOKUP([@[Resource Name]],'KY Headcount Assumptions'!$A$1:$E$9,5,FALSE)),""),0),0)

Qlik :

Assumed Production: Round(Sum(Load)/[Hours Per Day])

Assumed Production - 0

But the expected answer is 1

It seems like it's not rounding up 0 digits. Looks like its rounding up 1 digit

Any help would be greatly appreciated.

Thanks,

Pragna.

[sunny_talwar]

If you are looking to RoundUp, try Ceil() instead of Round() function

[Pragna · Accepted solution]

Hello Sunny,

Thanks for your quick response. I have used the Ceil function but it's not giving the correct answer.

Tried this formulae : Num(Round(Sum(Load)/[Hours Per Day]),'#0')

This worked!!!!!!!

Thank you.