cancel
Showing results for 
Search instead for 
Did you mean: 

How do I create a running total that looks for characters

former_member279138
Participant
0 Kudos
62

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 {user_values.markets} then 1

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Kurt,

The formula should be:

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

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

-Abhilash

Answers (0)