Skip to Content

WEBI Column Values Compare based on Condition

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


igjl5.png (91.2 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 28 at 06:30 AM

    Define the following variable:

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

    ....

    hopefully that helps


    mn.jpg (91.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.