2 Replies Latest reply on Feb 29, 2016 4:15 AM by Tharashasank Davuluru

    How to count multiple params in a calc

    Hannah Williams

      Morning,

       

      I'm trying to include multiple params in a calc, but am not sure how to format it.

       

      1 param works:

      IF [dKNumber] = 1014 THEN 1 

      ELSE 0 END

       

      Multiple params throws an error.

      IF [dKNumber] = ('1014','2912','2911') THEN 1  ELSE 0 END

       

       

      Thanks in advance

       

      Hannah.