Expression help

[surajap123]

Hi,

I have the below expression which I think is not very good for performance.

SUM(AGGR(COUNT(DISTINCT(IF(NominalName = 'Item Fees' AND Status <> 'Cancelled', CustID))),CustID,FMonth ))

Is it possible to re-write the expression, say changing sum() position in the expression)  or using set analysis.

Regards,

suraj

[christophebrault · Accepted solution]

Hi,

you could use this one :

SUM(AGGR(

COUNT(DISTINCT {$<NominalName = {'Item Fees'}, Status={'*'}-{'Cancelled'}>}CustID)

,CustID,FMonth ))

Using AGRR depends on your needs, the place you use the expression (text box, charts...)

[surajap123]

Thanks for the expression..