Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My task is to display the name of the media which has a zero budget disregarding a user's selection in the field 'media'.
I tried this formula:
Concat({<Media = {"=aggr(sum( {<Media=>}[Budget]), Media)=0"}>} distinct Media, ',')
It doesn't work the way I need. It still takes into account a user's selection in the field 'media'.
How can I fix it?
Thank you in advance,
Larisa
=Concat({<Media=>}aggr(if(sum({<Media=>}Budget)=0,only({<Media=>}Media)),Media),',')
=Concat({<Media=>}aggr(if(sum({<Media=>}Budget)=0,only({<Media=>}Media)),Media),',')
Thank you!