Automatic calculation

[#1]

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

[sujeetsingh]

Hi,

You can use Ceil()  or Floor() functions.