Create a formula. If none of the fields can be null, it will have this type of syntax:
{field1} + {field2} + {field3} + ...etc.
If any of the fields can be null, then you'll have to do something like this:
WhilePrintingRecords;
Numbervar mySum;
If not IsNull({field1}) then mySum := {field1} else mySum := 0;
If not IsNull({field2}) then mySum := mySum + {field2};
If not IsNull({field3}) then mySum := mySum + {field3};
...(add the rest of the fields)...
If not IsNull({field9} then mySum := mySum + {field9};
mySum
It's important that you have the final "mySum" without the semi-colon at the end or else the number won't display.
-Dell
IP Logged
