StringInCSV
EAZYBI Returns true if a string exists in another comma-separated string. Otherwise, returns false .
Syntax
StringInCSV(String, CSV)
Arguments
String | any string |
|---|---|
CSV | comma-separated string |
Examples
The following example will return the value of "Issues resolved" if the Status dimension member name is Done, Closed, or Resolved. Otherwise, the 0 result is returned.
Iif( StringInCSV([Status].CurrenthierarchyMember.Name,"Done,Closed,Resolved"), [Measures].[Issues resolved], 0 )