I am pretty new to Webi and am having an issue creating a variable. I'm trying to check if there is more than 1 email address for each group party id and if 1 of the contact names contains "Annual Report". So when I flag each group party id for no email only the ones without a contact name that contains "Annual Report" will be pulled. In the example above only they yellow groups she be called no email. Right now all of them are being pulled into no email.
- SAP Managed Tags:
Accepted Solutions (0)
Answers (1)
follow below steps to show only highlighted rows in webi report.
Create Variable V Show/Hide=If(Match([Contact Email Address];"*noemail*") And Count([Contact Email Address]) In ([ID])<=1) Then "Show" Else "hide"
Apply filter on table where V Show/Hide is equal to "Show".
check below screenshot for reference.
| User | Count |
|---|---|
| 87 | |
| 10 | |
| 9 | |
| 9 | |
| 9 | |
| 6 | |
| 6 | |
| 5 | |
| 4 | |
| 4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.