Count receipts with positive revenue

[stha142020]

Hi,

I want to count receipts with positive revenue.

How do I write a set analysis  from Count(distinct Receipt) that returns receipt 1 and 3?

Receipt	Revenue
1	100
2	100
2	-100
3	10
3	10
3	10
3	-10

Thanks!

[agigliotti · Accepted solution]

Hi @stha142020 ,

try this:

Count(  {< Receipt = {"=Sum(Revenue)>0"} >} distinct Receipt )

I hope it can help.

Best Regards

[stha142020]

Thank you!