Calculation field inconsistantly working

[TDebb8594]

I have a simple calculation field that is only calculating on some of my records, aprox. 3 out of 20 records.

The calculation is:

"Annual cost" / 2 * "billing weeks"

All fields are in the same table.

[Lee Smith]

Do not enclose your fiels in quotes.

Annual cost / 2 * billing weeks

Lee

[TDebb8594]

I was going to say (but didn't) that my calculation does not include the quotes around the field names.

[Lee Smith]

The calculation seems to be okay, can you post a copy of your file, or the field data that isn't working, i.e. the ones that are errors?

Also, be sure that the fields are Numbers.

Lee