Expression using set analysis

[#1]

Hi,

I have two columns from two different tables.

Employee	Payment
ID	PaymentID

I need to get TotalAmount as when PaymentID= ID so I write set anaysis like below

Sum({<PaymentID={ID}>}TotalAmount)

and TotalAmount values are in Payment table.

but when I am reloading it's shwoing £0 for all rows.

Could any one help me is there any error in set analysis expression

[CELAMBARASAN · Accepted solution]

Hi,

Sum({<PaymentID={"=PaymentID=ID"}>}TotalAmount)

Or

Sum({<UniqueID={"=PaymentID=ID"}>}TotalAmount)

[#3]

Thanks and it's working