Discussion board where members can learn more about Qlik Sense App Development and Usage.
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)
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.
View solution in original post
If you are looking to RoundUp, try Ceil() instead of Round() function