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!!!