Calculating division in Set Analysis

[#1]

Hopefully this will be a real easy one for somebody...

I am trying to calculate % variance using the following formulas;

(Actual - Budget) / Budget

or

1- (Actual/Budget)

e.g.

Actual	Budget
282751	287200	1.55%

However when i build these as expressions in QV i do not get the result i was expecting.

Here is my code

Would appreciate somebody having a look!

Cheers

Rob

[#2]

Sorry here is my code;

=1-(sum({$<Costcategory={Invoiced, [EYP], [Milk Grants], [Other Income]}>} Act)/2

/

sum({$<Costcategory={Invoiced, [EYP], [Milk Grants], [Other Income]}>} Bud)/2)

[Miguel_Angel_Baeyens]

Hello Rob,

First, unfortunately your code is not posted. Anyway, you can create a new expression, having already both Actual and Budgest as labels for two expressions like

=([Actual] - [Budget]) / [Budget]

This should work.