Check if value is possible

[sibrulotte]

Hi,

conditional calculations: I'd like to check if the value 'Bunny' is possible in the field [Animals], what would the formula look like?

Everytime I try to use P in my formulas I get an error (and I've checked the tutorials many times...)

[#2]

TRy to use wildmatch and concat functions.

ex.

wildmatch(concat(Animals,';'),'Bunny')

hope this helps

Mc

[rwunderlich · Accepted solution]

Or...

max(match(Animals, 'Bunny'))>0

-Rob

[Clever_Anjos]

or...

index(concat(Animals), 'Bunny'))>0

[er_mohit]

in calcualtion condition write

Fieldname='Bunny'

or

wildmatch(Fieldname,'Bunny')