This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
The below script is returning different rounding results. However I am expecting the result to be 0.7767 in place of IncorrectRoundResult column. How can this be fixed without using CEIL?
round(Num1/Num2,0.0001) as IncorrectRoundResult,
Num1/Num2 as NoRoundResult,
round(0.77665,0.0001) as CorrectRoundResult;
How about this?
A bit kludgy, but it works.
round(round(Num1/Num2, 0.00001),0.0001) as CorrectRoundResult,
View solution in original post
Look at this thread
This should return =Round(978579/1260000,0.0001)
Use ceil instead of round
I need to use the column names but not the actual values. When the actual values are used, it provides correct intended result
Ceil has issues like it would return 0.7666 for ceil(0.76653,0.0001)
Sunny already provide nice article. You can look diff of Floor and Ceil..
From Sunny provided link, i used ceil to get into work
Thank you Marcus. It worked.