4 Replies Latest reply on Jun 19, 2018 11:44 AM by Stephan Jones

    Calculated Field - Sum items were some are Null

    Stephan Jones

      Hello,

       

      Been spending too much time trying to figure this out and I know it involves a Null Calculation somewhere, but looking for some help.

       

      I have teammates that work multiple types of "cases". Some are trained in 1, some are trained in another, some trained in both. When I go to get a sum of the cases it won't total the individual if they have a null value.

       

       

      What do I need to do to the calculated field to change the nulls to 0 when summing things up?  I've attached a sample workbook with very basic data to show.