Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have Table1 with fields Quantity1, Quantity2 and QuantityKey, Table 2 with field Conversion1 and Table3 with field Conversion2.
I want to count the number of different QuantityKey with the following condition:
Quantity1 x Conversion1 - Quantity2 x Conversion2 is positive
Can someone help please. Thank you.
Hi
try this one :
Sum(AGGR(if(Quantity1*Conversion1-Quantity2*Conversion2>0,1,0),QuantityKey))
Hi
try this one :
Sum(AGGR(if(Quantity1*Conversion1-Quantity2*Conversion2>0,1,0),QuantityKey))