How to write aggr function using conditions?

[pallabi_jor]

Hi  All,

I need to  write aggregation of  count of project basesd on productId  along with two sum conditions, But I am getting result 0, which is  not correct. Could you please help me to write the code

equation:

Count( distinct if(Aggr(Sum({<ItemID={'1','3'}>} Price)>'0' and Sum({<ItemID={'115','120','130'}>} price)='0',ProjectId), ProjectId))

[ChennaiahNallani]

ItemId is string or number??

remove single quotes and try

[andrey_krylov]

Try this

=Sum(Aggr(if(Sum({<ItemID={'1','3'}>} Price)>0 and Sum({<ItemID={'115','120','130'}>} price)=0, 1, 0), ProjectId))