### 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!

Sum(

If (A>0;A);

If(B>0;B);

If(C>0;C)

)

also this allows for negative numbers

Sum(

If (not IsEmpty A; A);

If(not IsEmpty A;B);

If(not IsEmpty A;C)

)