also this allows for negative numbers
If (not IsEmpty A; A);
If(not IsEmpty A;B);
If(not IsEmpty A;C)
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.
@ab = If(not IsEmpty(B);A+B;"");
@ac = If(not IsEmpty(C);A+C;"")];
A>0 and @ab;
A>0 and @ac;
This assumes that there is never an B and C on a record at a given time. It will be B or C.
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 ( [
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 :)