performing calculations in the table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a form template with a table where user is going to enter values into form number fields. I want to calculate sum for each row. It is working if I use Calculation field, but it displays 0 when there are not entries. I am looking for solution which will display values when sum is greater than 0 and will be blank for sum equal 0. Is it possible to modify the formula in the calculation field ? I was trying to create macro to be executed on exit from the fields but I can not figure out how to calculate the sum which will be entered into the sum cell in the table. How I can solve my problem ??
Thanks for suggestion

Tony
 
Tony,

You could forgo the the calculation form field and just juse a =formula
field with a numeric switch in the cell you want to hold your sum.

e.g., { =sum(left) \# 0;(0); }

The field code brackets { } are entered with CTRL+F9
Ensure all of the fields holding values are set to calculate on exit.
 
Back
Top