If(Sum(<conditions>) = 0, count(var1), Null)

[jisephcirspy]

Hello, I want to count all the entries, where the sum equal 0 is. Otherwise it shouldn't count.

I tried:

=If(Sum({<category_name*=-{'Food', 'Clothes'}, [name]*=-{'-'}>} price)={0},Count(id),Null)

Can you help me?

[tresesco]

@jisephcirspy  Try like:

=Count({<id={"=Sum({<category_name*=-{'Food', 'Clothes'}, [name]*=-{'-'}>} price)=0">}id)

[jisephcirspy]

it prints "Error in set modifier ad hoc element list: ',' or ')' expected" @tresesco 

[tresesco · Accepted solution]

=Count({<id={"=Sum({<category_name*=-{'Food', 'Clothes'}, [name]*=-{'-'}>} price)=0"}>}id) @jisephcirspy  This?

[jisephcirspy]

IT WORKS!! THANK YOU  ❤️