3 Replies Latest reply on Sep 16, 2013 7:04 AM by Justin Smith

# can some one explain this?

Hello,

Can someone explain this to me?

AVG([actual value]) / AVG([Calculated setpoint])

The outcome of calculation 1 = 1,105

IF [Calculation1] = 1.105 THEN "A"

ELSEIF [Calculation1] > 1 THEN "B"

ELSEIF [Calculation1] < 2 THEN "C"

ELSE "D"

END

How does it come that the outcome of calculation 2 = B and not A ?

I do not get it. The fist line of calculation 2 = TRUE ? (1.105 = A)?

Really like to hear a answer because I am really confused.

Regards Bart

• ###### 1. Re: can some one explain this?

Bart,

Its because of the rounding. Calc 1 in your example is actually 1.10471... Since you are asking it to equal 1.105 it is skipping the first line, and the second is true.

Make your first line IF round([Calculation1],3) = 1.105 THEN "A"

and it works.

Justin

• ###### 2. Re: can some one explain this?

Justin Thanks,

Now that you mention it I feel a bit silly. But I'm glad I know.

It will not happen to me again.

Thanks again,

Bart

• ###### 3. Re: can some one explain this?

In all fairness, I had never ran across having to round in a calculation. I'm glad you had the question, or I would have been posting asking the same thing some day probably very soon! Have a good one.

Justin