Set Analysis only completed bills

[berndjaegle]

Hi guys,

I am looking for the correct set anlaysis.

Only completed bills should be calculated and shown.

When ALL of them Status= done, then sum(Faktura).

Example: only BillingNo 101 should be shown.

This intersection doesn't work:

sum({$ Status = {'done'} >*< Status={'open', 'in progress', 'done'} >} Faktura)

Can you help me?

[jwjackso · Accepted solution]

Try excluding BillingNo where there is a status other than 'done'.

sum({<BillingNo=E({<Status-={'done'}>}BillingNo)>}Faktura)