Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Do you have a solution for this issue? I have the same problem.
You need this expression in the text object ?
Use
Let vClaim and
Let vReception
to solve the problem.
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)
Hi,
Use = symbol in variables .you can get that.
have a look at attached QVW.