Set Analysis only completed bills

berndjaegle — Tue, 22 Jun 2021 15:38:25 GMT

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?

Re: Set Analysis only completed bills

jwjackso — Tue, 22 Jun 2021 16:01:41 GMT

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

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