Suming Multiple fields

[#1]

I have a table where I need to add four fields in order to create the necessary total. The field names are EQUIP, LABOR, PARTS,and OTHER. I tried a few different sum configurations but they don't return any data. Please help with the formula.

Thanx

[Anonymous]

Try something like:

Load
num(EQUIP)+ num(LABOR) + num(PARTS) +num(OTHER) as NewFieldName
from...

What happens?

[#3]

Dennis,

That doesn't seem to work.....it loads the table fine, but doesn't like the load statement. Is there a way the summation can be created in the chart expression?

[Anonymous]

Normaly that should work the same way.
Can you upload the file so I can have a look?

[#5]

On a Script????

Maybe not recognized as number.

Evaluate(sum(EQUIP))+Evaluate(sum(LABOR)+..... as NewFileName