11 Replies Latest reply on Mar 14, 2018 3:16 PM by Deepak Rai

    Help! Calculated field not working because of null

    Shawnee Cherman

      Hi,

       

      I am going crazy here trying to figure this out and it could possibly be an easy fix. I have a calculated field that returns a date however some nulls are returned. How do I get these nulls to display as a 0 or 1 instead of it saying null? Is that even possible? I ask because I then use this calculated field in another calculated field but it wont give me the correct results because of the nulls.

       

      my calculated field that returns a null has this formula: What I am looking for is a review date for any row that has review status and in to qa. Some reviews do not have this status so that is why it is returning a null.

      { FIXED [SM Review Id]:MAX(

      IF CONTAINS([Action Description],'Review Status') AND

      CONTAINS([Action Description],'to In QA')

      AND [Created On]<=[Review Status Date]

      THEN [Created on (date)]END)}

       

      Any ideas on what to do with the nulls? I need a way to remove them or have it place a 0 instead of null so i can use this calculated field in another calculated fields formula.

       

      Thank you,

      Shawnee