Simple irritating calc.

[Keith Shelton]

3 number fields: Field A qty x Field B qty = Field C total, e.g. 2 x 4 = 8.

Field C is set as Auto Enter Calc (A x :. This works but as soon as a figure is entered in A or B, a zero appears in C (total) and does not change when both A and B have entries. If the zero is deleted and either A or B entered again, then C shows correct total.

How can I overcome this as it is not practicable to delete the zero each time. Also I do not wish to change C to a Calculation or Summary field.

As always, any help is appreciated.

[WBlanchard]

Make sure all the field designated in the calculation are defined as number fields, and that the calculation itself is set to return a number. Odds are you have a text field set somewhere.

[Kurt Knippel]

quote:

---

Originally posted by Keith Shelton:

3 number fields: Field A qty x Field B qty = Field C total, e.g. 2 x 4 = 8.

Field C is set as Auto Enter Calc (A x :. This works but as soon as a figure is entered in A or B, a zero appears in C (total) and does not change when both A and B have entries. If the zero is deleted and either A or B entered again, then C shows correct total.

How can I overcome this as it is not practicable to delete the zero each time. Also I do not wish to change C to a Calculation or Summary field.

As always, any help is appreciated.

---

You NEED to change C to a pure calculation. The reason it works as it does is because it is an AUTO-ENTERED calculation. Once a value is entered in one of the fields in the calc is it evaluated and thus ENTERED. It does not wait for you to fill out ALL the fields in the calc.

Make it a regular calculation and it will work fine. Otherwise attach it to a script.

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=