calculation field to evaluate if a value is not included in a field (multiple choice)

Follow

Joseph ARACIC

• August 30, 2017 15:53

Hi,

In an app I have a multiple choice field (Activity Type).

Since it is not possible to create a OR filter on a NOT filter (at least vith the Browser UI), I planned to create this calculation field in javascript :

if (("PossibleValue1" in @Activity Type)) { false } else { true }

But the result is ALWAYS 1.0 (true)

Does someone has a solution ?

If I'm not clear enough, my objectif if to find out all items that does not have the value "PossibleValue1" in the "Activity Type" multiple choice field.

Thanks for your help.

regards.

Joseph

 

0

• 

  Rainer Grabowski

  • September 01, 2017 06:29

  Hi Joseph,

  I think you're looking for this:

   @Activity Type.indexOf("PossibleValue1") > -1 ? "false" : "true"

  Rainer

   

  0

  Comment actions Permalink

Please sign in to leave a comment.