2 Replies Latest reply on May 14, 2013 1:36 PM by Ryan Johnson

    Help with IF THEN statement

    Ryan Johnson

      I'm trying to write a calculated field that inserts a different value if the specified value is null or 0.  I tried: IF [ADJUSTED_AMOUNT] = NULL OR [ADJUSTED AMOUNT] = 0 THEN [PROJECT_TOTAL] ELSE 0 END

       

      But T doesn't seem to like that.  What am I doing wrong?  Ugh!