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

    Jason Liau

      Hello,

       

      Not sure why this following expression doesn't work:

      if(Sum([Social-Mo])>=$(=4)<=$(=5),2340000*Sum([Social-Mo]))


      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!