Aggr sum expression issue

[irmantas]

Hello,

I need Aggregate SUM from different tables. Like this simple ex:

I was use Aggr(sum(Purch),CustId=VendId) but expression do not works. Please help me.

[Arthur_Fong]

Try:
Aggr(sum(if(CustId=VendId,Purch)),CustId)

[irmantas]

Seems right, but in my real expression do not works.

[irmantas]

In my real situation, SUM  have some IF's.

SUM(Purch) in really is: sum(if(DUEDATE<=Today(),Purch))

How i must change your expression to be correct?

[Arthur_Fong · Accepted solution]

Try this:

Aggr(sum(if(CustId=VendId and DUEDATE<=Today(),Purch)),CustId)

[irmantas]

March better:) Expression works:)