Number of clients with payment term greater than 15 days and total revenue smaller than 100$

[avantime]

Hi,

I have a problem resolving this issue. Right now I have:

=count(distinct {<[Client name]={"=sum(Invoices)<100"}>}{<PaymentTerm={"=PaymentTerm>15"}>} [Client name])

Payment term of over 15 days is working. The sum of invoices is not taken into account. What am I doing wrong?

Thank you!

[swuehl · Accepted solution]

Only use a single set expression (single pair of {..} ) and combine your field modifier like

=count(distinct {<[Client name]={"=sum(Invoices)<100"}, PaymentTerm={"=PaymentTerm>15"}>} [Client name])

(maybe

=count(distinct {<[Client name]={"=sum(Invoices)<100"}, PaymentTerm={">15"}>} [Client name])

works the same)

A Primer on Set Analysis

[avantime]

You... rock! Thank you so much!