cancel
Showing results for 
Search instead for 
Did you mean: 

How to compare 2 columns data?

chandrasekhar6
Participant
0 Kudos

Hi Team,

How to compare 2 columns data in the SAP BO Webi as like below,

Thanks,

Chandrasekhar

Accepted Solutions (0)

Answers (3)

Answers (3)

sgperam
Participant
0 Kudos

Hi Chandra,

It is typo.

=if(managerid =previous(manager ID)) then " " else D.

Refer this blog

Thank you

sgperam
Participant
0 Kudos

Hi,

You can try with previous function.

=if(managerid =previous/9manager ID) then " " else D.

Sort the webi report by user ID and Manager ID

Thank you

chandrasekhar6
Participant
0 Kudos

Thanks Sesha.

Can you please let me know in the formula "/9" it is available or nor

=if(managerid =previous/9manager ID) then " " else D.

Sruti_P
Participant
0 Kudos

Hi Chandra,

You can create a variable var_compare=If ([User ID]=[Manager id]) Then 0 else 1

Here 0 matches the column value and 1 not.

Regards,

Sruti

chandrasekhar6
Participant
0 Kudos

Hi Sruti,

Thanks for your reply.

I have already applied above formula, but it is not working.