10 Replies Latest reply on May 22, 2014 4:31 PM by Thi To

    IS NULL AND IS NOT NULL

    Thi To

      Hi!

       

      I am trying to create a calculated field based on whether the Cash & Credit fields is NULL or NOT NULL

       

      IF ISNULL([Cash_Num]) then 'Credit'

      ELSEIF ISNULL([Credit_Num]) then 'Cash'

      ELSEIF NOT ISNULL([Cash_Num]) AND NOT ISNULL ([Credit_Num]) then 'Mixed'

      END

       

      For some reason the 'Cash' field where CreditNum is NULL does not calculate

       

      Is there something wrong in my calculation?

       

      Please see attached. If you can help that would be great

       

      Thanks