Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try line below
Variable:
vInvoiceFlag = if(Sum(InvoiceFlag)>1 and sum(InvoiceFlag)<5,CompanyID)
Expresion:
count({$<CompanyID={"=$(vInvoiceFlag)"}>}distinct CompanyID)
try line below
Variable:
vInvoiceFlag = if(Sum(InvoiceFlag)>1 and sum(InvoiceFlag)<5,CompanyID)
Expresion:
count({$<CompanyID={"=$(vInvoiceFlag)"}>}distinct CompanyID)
Hi Louis,
Please try the below -
count({<CompanyID={"=sum(InvoiceFlag)>1" }>
+
<CompanyID={"=sum(InvoiceFlag)<5" }>
} distinct CompanyID)
Thanks,
RT