
1. Re: Calculation that includes empty Fields
ChrisJohnston Apr 21, 2015 7:19 PM (in response to gremlin9297)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)
) 
2. Re: Calculation that includes empty Fields
gremlin9297 Apr 23, 2015 4:27 PM (in response to gremlin9297)That solved the empty field but the calculation is only suppose to run if all all the fields were greater than zero. The calculation your provided runs as long as at least one of the fields is greater than zero. In other words it should only be calculating the fields if A and B or A and C are greater than zero.

3. Re: Calculation that includes empty Fields
ChrisJohnston Apr 23, 2015 8:59 PM (in response to gremlin9297)Let(
[
@ab = If(not IsEmpty(B);A+B;"");
@ac = If(not IsEmpty(C);A+C;"")];
Case(
A>0 and @ab;
A+B;
A>0 and @ac;
A+C;
""
)
)This assumes that there is never an B and C on a record at a given time. It will be B or C.

4. Re: Calculation that includes empty Fields
gremlin9297 Apr 24, 2015 12:18 PM (in response to gremlin9297)That was what I was looking for, though I did have to modify it a bit. The calculation you provided made the calculation regardless if the record was greater than zero. The calculation had to make sure both fields were greater than zero or else ignore it.
Let ( [
bb=If(not IsEmpty(B);B;"");
cc=If(not IsEmpty(C);C;"")];Case(
A>0 and bb>0;A+B;
A>0 and cc>0;A+C))thanks again for the help. Definitely got me through this problem :)