All eazyBI for Jira eazyBI for Confluence Private eazyBI

StringInCSV

EAZYBI Returns true  if a string exists in another comma-separated string. Otherwise, returns false . The function searches for an exact match, so avoid any unnecessary spaces or other symbols in the CSV string.

Syntax

 StringInCSV(String_Expression, CSV_Expression)

Arguments

String_Expression

MDX expression returning a string to search for in the CSV_Expression

CSV_Expression

MDX expression returning 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
)


See also

  • Function InStr returns the position of the first occurrence of one string within another.
  • Function IIf evaluates different branch expressions depending on whether a Boolean condition is true or false.