Field1 > Field2 greater than Count in Set Analysis

[chandu441]

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

[Taoufiq_Zarra · Accepted solution]

Maye be :

=count({< Customer={"= Field1>Field2"}>} Customer)

an example :

[chandu441]

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