3 Replies Latest reply: Oct 21, 2013 5:02 PM by Aurélien Martinez

# Problem with two variables

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:

MonthYearSupplierTypeQuantity
01/2013AReception25000
01/2013AClaim1000

• ###### Re: Problem with two variables

Hi,

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

Regards

Aurélien

• ###### Re: Problem with two variables

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

Could you explain it with words?

Best regards,

• ###### Re: Problem with two variables

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