topic Problem with two variables in Water Cooler

Problem with two variables

inigoelv — Mon, 21 Oct 2013 17:30:38 GMT

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 — Mon, 21 Oct 2013 18:46:26 GMT

Hi,

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

Regards

Aurélien

inigoelv — Mon, 21 Oct 2013 20:55:45 GMT

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 — Mon, 21 Oct 2013 21:01:30 GMT

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