Problem formul with 2 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.

[#2]

Do you have a solution for this issue? I have the same problem.

[#3]

You need this expression in the text object ?

[#4]

Use

Let vClaim and

Let vReception

to solve the problem.

[maxgro]

using input box with these expressions

vC  =         Aggr ( Sum ({<Type={"Reception"}>} Quantity), MonthYear, Supplier)

vR =         Aggr ( Sum ({$<Type={"Claim"}>} Quantity), MonthYear, Supplier)

I get 0.04 for

=$(vC) / $(vR)

[chiru_thota]

Hi,

Use = symbol in variables .you can get that.

have a look at attached QVW.