Count if sum(value) ist not 0

[LisaG]

Hi,

I have to count the date only if the net revenue on the day is not equal to 0. Also the net revenue needs to be summed up to the date before the condition: net revenue not equal to 0 is checked.

I am trying to use this, but it doesn't work:

Count({<[%DAT]={sum([net revenue]) <> 0}>} distinct [%DAT])

Thanks a lot,

Lisa

[Gysbert_Wassenaar · Accepted solution]

Try: Count({<[%DAT]={"=sum([net revenue]) <> 0"}>} distinct [%DAT])

[LisaG]

Thanks a lot, it worked!