Discussion Board for collaboration related to QlikView App Development.
I need to restrict the values on a table upto 2 decimal points with rounding off the values.
Ex: if value = 0.556, I need the value as 0.55 and not 0.56.
I tried using the Floor(value, 0.01) function and Left(Value,4), But these functions doesn't give the desired output.
- Am also suppressing the null values that is one of the reasons am facing issue.
Can anyone please help me out here?
Would you be able to share a sample where you have this problem?
Floor() will helps you. Can you share image?
Try using this
floor(0.556, 0.01) gives 0.55
what's wrong for you ?