[RBASE-L] - Re: Report variable ?

[A. Razzak Memon]

At 01:43 PM 3/9/2009, Steve Breen wrote:

This will not work
Discount = Discount_Amt in Cust_Discount Where CustNub2 = CustNub2 
and  PON in (Sel PON from Charges where ChargeType = 31 or ChargeType = 32)


Steve,

Try the following expression and see what you get.

Discount = Discount_Amt IN Cust_Discount WHERE CustNub2 = CustNub2 
AND PON IN (SELECT PON FROM Charges WHERE ChargeType IN (31,32))

Very Best R:egards,

Razzak.