3 Replies Latest reply: Jun 29, 2015 3:52 PM by Sunny Talwar RSS

    Attempt to narrow down what needs attention using isnull

    Myles Holland

      Hello community,

       

      I'm working on an expression to help narrow down when my colleagues miss a step in the process.

       

      Basically if Step 3 is complete (not Null), but either step 1 or 2 is not (Null) work needs to be down.

       

       

      =count(DISTINCT if([Load Date]=vLatestDate AND Isnull([Step1- Actual]) AND IsNull ([Step2 - Actual]) , [Project Number]))

       

      works in providing me with situations where Step1 or 2 are null.

       

      However, I'm not sure how I can ask the question to include Step3 is not Null.

       

      Any advice on this?

       

      Regards,

       

      Myles