Showing results for 
Search instead for 
Did you mean: 

How do I create a running total that looks for characters

0 Kudos

I have a field that returns multiple values so I could get anything from "1" or "4" or "1&4" or "1&4&6" or "2&5"

Would it be possible to create a running total that would only count the field if it included a certain character like "1"?

I tried this formula but it just returned 0

If '1' in {} then 1


Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos

Hi Kurt,

The formula should be:

If Instr({}, '1') > 0 then 1

Insert a summary against this formula field with its Summary function set as 'Sum'.


Answers (0)