14 Replies Latest reply on Oct 5, 2018 8:18 AM by Joe Oppelt

    All fields must be an aggregate or constant

    tarang.patel.3

      Hi,

       

      I am having trouble with an aggregate and constant in my calculations. This is what I have so far...

       

       

       

      if [index] = 1 then "Include"

      ELSEIF lookup([Number of Employees],-1) = LOOKUP([Number of Employees]) then "Do Not Include"

      ELSE

      "Check formula"

      END