Aggr with Sum IF only works selecting one variable

[Anonymous]

Hey everyone

I really hope you can help with this problem.

I have this function which works perfectly when I'm only selecting one order or one customer:

IF(Aggr(sum({$<CAL_YEAR =, CAL_MONTH =,CAL_DAY=, AD_P_DATE={'>=$(=MonthStart(Today(),-12))<$(=MonthStart(Today()))'}>} NET), CUSTOMER) = '0', Sum(IF(CUSTID <> 'IA' And CUSTID <> 'KA' And CUSTID <> 'BA' AND PLACE <> 'BBB', NET)))

However, if I don't select a specific customer or order, nothing happens besides getting  - .

Can anyone explain what I'm doing wrong? I have searched around the internet, and I have been able to find some similar problems with a solution. However I haven't been able to implement those solution to my expression.

Stefan

[sunny_talwar]

I guess your issue is common issue of Return/New/Lost customer... see if this thread helps

New/Lost/Returning/Loyal Customers