Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Try excluding BillingNo where there is a status other than 'done'.
sum({<BillingNo=E({<Status-={'done'}>}BillingNo)>}Faktura)
Try excluding BillingNo where there is a status other than 'done'.
sum({<BillingNo=E({<Status-={'done'}>}BillingNo)>}Faktura)