WEBI Column Values Compare based on Condition

[former_member630262]

Hi Guys,

I have scenario where i implemented Input control as Search bar (Entry field) in Webi report (SAP BO 4.2Sp7p1). I created some variables to find the input string in the data set. In below case my input is "A61". "Classification Like" variable determine the string and give the result as "Match" and "No Match"which i will subsequently display in the report by using table level filter.

Now the new requirement is once any search string matched with corresponding value then rest of all value should also display for each company/Document Number

So in case A61 search , we have same document Number but two different companies, rows Match which have A61. Need to convert No Match values as Match - so it means if any company has at least one Match rest all No Match turned to Match.

Note; If any company which has no value match then all No Match values remain stay as it.

Any Suggestions Please.

Thanks

[ayman_salem · Accepted solution]

Define the following variable:

Classfication Like (NEW): =If(Min([Classification Like]) In ([Assignee Name]) = "Match") Then "Match" Else [Classification Like]

....

hopefully that helps

[former_member630262 · Accepted solution]

Thank you very much Ayman for your help!

This formula is working fine when there is at least one "Match" against Document Number/Assignee name so its convert "No match" to "Match" which is fine but if all values of Document Number/Assignee Name has "No Match" its again convert to "Match" as highlighted.

Should we have to include Document Number in the condition too? One Document Number can have multiple Assignees.

Screen shot is attached.

[ayman_salem · Accepted solution]

I wonder what happened in your example. If you see my example, it works fine.

Can you write the formula that you use?

Also check the relationship between "Assignee Name" and "Document Number" (if the "Assignee" have multiple "document numbers"). If so, add the "document number" to the "In" part

[navakh · Accepted solution]

Yes, one document can have more than one Assignee Names. Just add "Document Number" in IN clause along with Assignee Name.

Today I have no chance to work on it, busy with some Prod issue. Will let you know tomorrow about the following expression results. Hope it will work.

=If(Min([Classification Like]) In ([Document Number];[Assignee Name]) = "Match") Then "Match" Else [Classification Like]

Thanks again!

[former_member630262 · Accepted solution]

Hi Ayman,

By adding the Document Number into formula, its works perfect!

=If(Min([Classification Like]) In ([Document Number];[Assignee Name]) = "Match") Then "Match" Else [Classification Like]

really appreciate your help.

Thanks again!

Regards

Nav

[ayman_salem · Accepted solution]

glad to hear that helps.

Please accept the answer and close it