Calculating Field

[Jade]

I have a calculating field in a table. By default, the
field displays zero if none of the underlying cells have
values. Is there any way for me to change the calculating
field to appear blank rather than display a zero when
there are no values entered in the underlying cells?

Thanks

 

[mickey]

Try using a formula for the total field instead of a form
field. Go to Table, Formula then type in formula when
dialog box comes up. (sample:{=SUM
(g7,g8,g9,g10,g11,g12,g13) \# "#,##0.00;(#,##0.00);''" })