topic Re: Rounding Up 0 digit Issue in App Development

Rounding Up 0 digit Issue

Pragna — Fri, 22 Mar 2019 15:26:08 GMT

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.

Re: Rounding Up 0 digit Issue

sunny_talwar — Fri, 22 Mar 2019 15:44:24 GMT

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

Re: Rounding Up 0 digit Issue

Pragna — Fri, 22 Mar 2019 16:02:54 GMT

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.