Total Count

[superjermsss]

Hi Everyone,

I need help formulating how to calculate the total number of invoices shown below. I want the total number of invoices to display zero if the count only reflects resolved invoices, or if the number of resolved invoices exceeds the pending status and additional items.

Below is my current formula.

=Count(distinct{$<[Daily Comparison-2.Report Date]={'4/8/2026'}>}[Daily Comparison-2.Invoice Number]) + Count(distinct{$<[Daily Comparison-2.Status]={'Additional items'}>}[Daily Comparison-2.Invoice Number])
- Count(distinct{$<[Daily Comparison-2.Status]={'Resolved'}>}[Daily Comparison-2.Invoice Number])

[marksouzacosta]

Hi @superjermsss ,

What about this?

=RangeMax(Count(distinct{$<[Daily Comparison-2.Report Date]={'4/8/2026'}>}[Daily Comparison-2.Invoice Number]) + Count(distinct{$<[Daily Comparison-2.Status]={'Additional items'}>}[Daily Comparison-2.Invoice Number])
- Count(distinct{$<[Daily Comparison-2.Status]={'Resolved'}>}[Daily Comparison-2.Invoice Number]),0)

Regards,

Mark Costa

[Goldy-chicken]

I think your logic is very close, but the issue is coming from combining separate counts, which can easily produce a negative value when resolved invoices are higher than the others. In Qlik, a common fix for this is to check the whole expression in a condition so it never goes below zero. Instead of letting the calculation go negative, you can force it to return 0 when that happens. A simple approach like using Max(0, your expression) usually solves this kind of invoice balancing problem.