Simple irritating calc.

This topic is 8781 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Share on other sites

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.

Share on other sites

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]

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

Share on other sites

This topic is 8781 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

• Similar Content

• Is there a file Size limit?

By g.wrighton,

• 1,246 views
• Error 2022

By mcclamma,

• 1,489 views
• Convert FM Pro to MS Access

By jamesb,

• 2 replies
• 1,458 views
• Deleting Fields

By Sarah,

• 2 replies
• 1,346 views
• Finds across multiple fields and records

By jmichea,

• 2 replies
• 1,351 views
×
×
• Create New...

Important Information

By using this site, you agree to our Terms of Use.