comparing 2 fields that means 2 objects in webi

[Former Member]

Hi Gurus, I have a report and I need to compare 2 fields having the same boolean values 1 and 0.My work is to find the number of rows having the same boolean value "0".I tried a lot but cannot solve that can u guys share ur thoughts.

thanks,

San

[Former Member · Accepted solution]

I am not sure If I understand you correctly . But try -

Flag=if(var1=0 and var2=0) then 1 else 0

Count(Flag)

I hope this help

[Former Member · Accepted solution]

Yes, I solved it by using the where condition.It is working.Thanks for the suggestion

[former_member210032]

HI Santhosh,

Can you share how you solved your issues.

Regards

Mustafa