A total on the function if

[Anonymous]

Hello,

I have a table by customer code on which I managed to calculate the number of new customers. The objective is to get only this sum in an object without the table of details.

Min_date= aggr(  min({<Date=>}    Date),[Code Client])

New = if (aggr(  min({<Date=>}    Date),[Code Client])<AddMonths(vDateDébut,-24), 1, 0)

Thank you for your help

[sunny_talwar]

May be this

Sum(Aggr(If(Min({<Date=>} Date) < AddMonths(vDateDébut,-24), 1, 0), [Code Client]))

[sunny_talwar · Accepted solution]

Or may be this

Sum(If(Aggr(Min({<Date=>} Date), [Code Client]) < AddMonths(vDateDébut,-24), 1, 0))

[Anonymous]

Thanks lot for your help it's work