3 Replies Latest reply on Jun 10, 2016 8:39 AM by Joshua Milligan

    Want Null Values to be added in a calculation

    Shyamal Patel


      PFB the desired output. I am not able to figure out "How to add  NULL values in my formula for "Valid rejection Reason count". So i want All RejectReasons including Null but minus reason "C"


      I tried this formula but as you can see it does not add Null


      if ([Detailsrejectreason] != "C")

      THEN ([Number of Records])



      Appreciate your help !!!