Skip navigation

2 Replies Latest reply on Apr 7, 2015 12:59 PM by matt.lukoff.0

calculated field where string contains

matt.lukoff.0 Apr 7, 2015 12:48 PM

Hello, how can I create a calculated field of a string where string contains "xyz"? It's basically count(STRING) where STRING = XYZ

1. Re: calculated field where string contains

Bora Beran Apr 7, 2015 12:55 PM (in response to matt.lukoff.0)

Try

SUM(IF CONTAINS([Your string field here],'abc') then 1 else 0 end)
Like Show 0 Likes(0)

Actions
2. Re: calculated field where string contains

matt.lukoff.0 Apr 7, 2015 12:59 PM (in response to Bora Beran)

perfect, thanks Bora!
Like Show 0 Likes(0)

Actions

Go to original post

More Like This