### Title

Calculation Help

### Post

FM PRO 11

OSX 10.6

Hello!

I have three fields "number of jobs", "Fee per Job" & "Total". I would like to make a calculation that will solve the empty field if 2 are filled in. So if i have "Total" & "number of jobs" it will figure out "fee per jobs"... If i have "number of jobs" & "Fee per job" it will figure out the total and so on..

Thanks for your time.

Ricardo

Total.

I'm assuming Number of Jobs * fee per job = Total

Define all three fields as number fields

Double click them in Manage | Database | Fields, select the auto-enter tab in the dialog that pops up.

Select the calculation option and enter the following expressions for each field:

Number of Jobs:

If ( fee per job ≠ 0 ; Total / fee per job ; "" )

fee per job:

If ( number of jobs ≠ 0 ; Total / Number of Jobs ; "" )

Total:

Number of Jobs * fee per job

For all three fields, clear the "Do not replace existing value..." check box after you've entered the calculation.