AnsweredAssumed Answered

Calculation field cannot be modified: "the specified field cannot be found"

Question asked by rgi on Jun 7, 2011
Latest reply on Jun 7, 2011 by philmodjunk

Title

Calculation field cannot be modified: "the specified field cannot be found"

Post

I have inherited a Filemaker database that has been updated from v4 and has had a couple of developer hands on it.  The database functions well in FM11, and we want to add two fields to job budgeting. There is a calculation field that compares hours entered to hours budgeted to identify when a job is approaching or over budget in given areas. However, I can't modify that calc field at all; in fact, opening and pressing ok without making any change generates the same error: "the specified field cannot be found". Everything is working as it should, but frankly this level of calculation is beyond my understanding of Filemaker calculations. You can see in the screen shot what field is being identified.  Here is the text of the calculation as well:

If(GetRepetition ( FLAG ignore budget;2)=1;"";Budg Prod+Budg Comps+Budg Copywriter-Sum(${Job.Time{Production}}::C hours))

Thanks in advance for any direction.

Screen_shot_2011-06-07_at_3.41.03_PM.png

Outcomes