4 Replies Latest reply on Apr 24, 2015 12:18 PM by gremlin9297

    Calculation that includes empty Fields

    gremlin9297

      Title

      Calculation that includes empty Fields

      Post

      I have returned!

      New dilemma, I have a calculation: 

      If ( 

      A > 0 And

      B > 0 And

      C > 0 ;

      Sum (
      A;

      B;

      C;

      ))

      Problem is that field C was being used for previous years, it has been replaced with B going forward. So I need the calculation to work regardless if the field is empty or not. Any help would be great. THANKS!