Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Pragna
New Contributor III

Rounding Up 0 digit Issue

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.

 

1 Solution

Accepted Solutions
Highlighted
Pragna
New Contributor III

Re: Rounding Up 0 digit Issue

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.
2 Replies

Re: Rounding Up 0 digit Issue

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

Highlighted
Pragna
New Contributor III

Re: Rounding Up 0 digit Issue

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.