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

      Hi,


      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])

      END

       

      Appreciate your help !!!