5 Replies Latest reply: Nov 11, 2014 8:45 PM by jagan mohan rao appala RSS

    IF Sum of [Field] equals X or Y Expression



      Not sure why this following expression doesn't work:


      If the Social-Mo field equals or is between 4 and 5, then multiple the sum of the Social-Mo field by 2,340,000. Can you let me know where I went wrong with this?

      Also, ideally I would want it to be EITHER 4 or 5 but not sure what expression to use since OR is not valid. Thanks!