IF Statement to Set Analysis in Concat() function

[manideep78]

Dear Community,

Please write the below expression in set analysis without using IF Statement.

=Concat(IF(aggr(Sum(Revenue),Product)>300,Product),',')

Thanks in advance.

Regards,

Manideep

[jerem1234 · Accepted solution]

Try:

=Concat({<Product = {'=sum(Revenue)>300'}>}Product, ',')

Hope this helps!

[manideep78]

Perfect! Thank you