3 Replies Latest reply on Jul 22, 2016 9:50 AM by Diogo Braga

    IF NULL THEN 'no goal'

    Diogo Braga

      Currently, I have this working calculated field.


      AVG([SLF Actual])>avg([SLF Goal]) then 'Target Met'

      ELSE 'Target Not Met' END


      Now, I need to add another layer in cases when SLF Goal is NULL, in this case I would like the formula to return 'no goal'


      How do I add the IFNULL, 'no goal' to the formula above? Thanks!