Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I am having three Columns Field1, Field2 & Customer. I have to count the Customers which the condition is below in simple if.
=if(Field1>Field2, Count(DISTINCT Customer), 0)
I want to change this in Set Analysis in UI level. Please help me on this.
Thanks
Satya
Maye be :
=count({< Customer={"= Field1>Field2"}>} Customer)
an example :
Maye be :
=count({< Customer={"= Field1>Field2"}>} Customer)
an example :
Hi Taoufiq,
I've tried myself before getting your solution.
=Count( {<Field1 = {"=Field1 > Field2"} >} DISTINCT(Customer) ) It worked from me.
Even your solution also getting worked out for the scenario.
Thanks
Satya