Sum Conditional in Set Analysis

[Anonymous]

HI,

This statement seems to not be working at all

=count({<{$(=sum(InvoiceFlag))}={'$(>1)'}>} distinct  CompanyID)

The aim of the expression is to count the CompanyID's where the sum of the invoice flags is greater then 1.

Regards

[sivarajs]

Hi,

store sum(invoice fllag) in a seperate variable

Then use syored variable here in the expression

Sivaraj S

[#3]

Take sum(Invoiceflag) in a variable say var1

and use this:

=count({<$(var1)={'>1'}>}distinct  CompanyID)

[#4]

=count({<var1'>1'>}distinct CompanyID)

[Anonymous]

Hey Acrobat,

Thanks for this input.

This solution doesnt work, I think it is because the sum in the variable is used across all of the companies whilst the actual expression is for one company.

That is why I tried to package this all into one expression with set analysis.

[#6]

Hi  hamishimrie,

just use this

=count( {<InvoiceFlag={ '>1'} >}    CompanyId) 

it works!!

please find attachement eee.qvw

Warms Regards,

Anant Dubey

[CELAMBARASAN · Accepted solution]

Hi,

Check with this

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

Celambarasan

[Anonymous]

hi Celambarasan,

Is it possible to

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

something like that.

Thx.

Best Regards,

Louis