topic Re: Count if sum(value) ist not 0 in App Development

Count if sum(value) ist not 0

LisaG — Wed, 22 Dec 2021 15:42:54 GMT

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

Re: Count if sum(value) ist not 0

Gysbert_Wassenaar — Wed, 27 Mar 2019 17:14:13 GMT

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

Re: Count if sum(value) ist not 0

LisaG — Thu, 28 Mar 2019 14:41:27 GMT

Thanks a lot, it worked!