Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Together,
I am using the below expression.
=Count(distinct{$-1<Material>} If([Price]>1,1,0))
I want to count the material where the equal price appears more than once in the list.
Thanks for your help.
Kind Regards,
Daniel
@Daniel1908 try below. If doesn't worl share sample data with expected output.
= count(if(aggr(count(Price),Material,Price) > 1 , Material))