Problem with two variables

[inigoelv]

Hello:

I have problem with the use of two variables in a formula:

1) vReception= Aggr ( Sum ({<TYPE={"Reception"}>} Quantity) MonthYear, Supplier) . Per example: 25.000 kg

2) vClaim= Aggr ( Sum ({<TYPE={"Claim"}>} Quantity) MonthYear, Supplier) . Per example: 1000 kg

When I calcul in an expression:

%=$(vClaim)/$(vReception) the result is only the first formul: 1000 kg instead of 1000/25000= 0,04

The result is like only use the first formul an forget to divide by the second.

The table is:

MonthYear	Supplier	Type	Quantity
01/2013	A	Reception	25000
01/2013	A	Claim	1000

Thanks in advance.

[Aurelien_Martinez]

Hi,

see the attachment. It's what you want to do?

Regards

Aurélien

[inigoelv]

Thanks for your answer but I have an edition personal and can not open the file.

Could you explain it with words?

Best regards,

[Aurelien_Martinez]

And the expression is $(vClaim) / $(vReception)