Loading

Counting Occurrences of a String Within a Dimension

Publiceringsdatum: Apr 30, 2025
Uppgift
How to count the number of times a particular text string occurs within a dimension.
Steg

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

001458221

 
Laddar
Salesforce Help | Article