Loading

Counting Occurrences of a String Within a Dimension

Publiseringsdato: Apr 30, 2025
Oppgave
How to count the number of times a particular text string occurs within a dimension.
Trinn

Option 1:

Use a calculation similar to the following to count how many times the substring occurs in any value of the dimension [String].

COUNT(IF CONTAINS([String],"substring") THEN 1 END)

Or alternatively

SUM(INT(CONTAINS([String],"substring")))

Option 2:

Use a calculation similar to the following to count occurrences of a string value within a dimension:

COUNT
(IF CONTAINS([DIMENSION],'VALUE') == TRUE THEN [DIMENSION]
END) 
Knowledge-artikkelnummer

001458221

 
Laster
Salesforce Help | Article