Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey All,
I'm working on a Qlikview Document and I want to make an automatic sum, but I can't seem to figure out how to do it...
It works like this: I've got a number that consists of 2 different numbers: like 5.1 or 4.2
the second number can only be 0, 1 or 2 because everything above that would be divided by 3 and the rest would be 0, 1 or 2 again. So imagine I have:
4.2+5.1 then it have to be 10.0, but now it is 9.3
Can someone help me?
Thanks in advance
Hi,
You can use Ceil() or Floor() functions.