Skip to Content
0
Jun 19, 2018 at 07:23 PM

Variable with Alerter - Help!!

70 Views Last edit Jun 19, 2018 at 07:22 PM 2 rev

Currently using SAP Business Objects Desktop Intelligence XI

Scenario 1:

Would like to create a variable with an alerter to highlight data not in the list. The value being evaluated is Automatic Doors and each door contains a frequency for inspections. Example Door 1 will have Annual and next row with Door 1 will have Semi-Annual. I am trying to create an appropriate Variable so that when I create and alerter that I can identify which Door does not contain both required Values of Annual and Semi-Annual. Especially if one Door Value only list Annual, I want to flag it with an alerter that it's missing an additional frequency.

Additional Scenario:

Also to throw an additional wrench I would like few Doors that will have a third frequency of Monthly, but I don't want the Variable or Alerter to flag but ignore the value as longs as it contains the required Annual and Semi-Annual.

So far this what I had been working with in terms of the Variable

= If (<Nomenclature>) InList ("AUTOMATIC DOOR") And (<Frequency>)<>"ANNUAL" And (<Frequency>)<>"SEMI-ANNUAL" Then 1 Else 0

Any help or guidance is greatly appreciated!!!