Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
ItemId is string or number??
remove single quotes and try
Try this
=Sum(Aggr(if(Sum({<ItemID={'1','3'}>} Price)>0 and Sum({<ItemID={'115','120','130'}>} price)=0, 1, 0), ProjectId))