Sum Conditional in Set Analysis

[Anonymous]

HI,

This statement seems to not be working at all

=count({<CompanyID={"=sum(InvoiceFlag)>1 & sum(InvoiceFlag)<5" }>} distinct  CompanyID)

How to define in set analysis?

Thanks a lot.

Best Regards,

Louis

[ChennaiahNallani · Accepted solution]

try line below

Variable:

vInvoiceFlag = if(Sum(InvoiceFlag)>1 and sum(InvoiceFlag)<5,CompanyID)

Expresion:

count({$<CompanyID={"=$(vInvoiceFlag)"}>}distinct  CompanyID)

[Neymar_Jr]

Hi Louis,

Please try the below -

count({<CompanyID={"=sum(InvoiceFlag)>1" }>

+

<CompanyID={"=sum(InvoiceFlag)<5" }>

} distinct  CompanyID)

Thanks,

RT