I have a file in which I have my net worth by year and the percent change from one year to the next year; e.g. flwg fields:

Year End; Net Worth; △ Net Worth; % Change.

My equations for those fields are:

c_△_net_worth Calculation n_net_worth - (GetNthRecord ( n_net_worth ; Get ( RecordNumber ) - 1 ))

c_%_change Calculation c_△_net_worth / n_net_worth.

Everything works fine except the annoying question-marks in the first year's fields of △ Net Worth and % Change.

I've tried variations of the If statement to eliminate them without getting a useable equation. I looked at Case but it didn't seem to fit.

I've read the FMP12 Help "Replacing the contents of a field" but didn't understand how those could be applied to my situation.

What Function or Equation can I use to eliminate the ? in those first year's fields? Maybe replace them with N/A.

An if statement in your calculation field might help. So for the Net Worth calculation, test to see if it is the first record or not:

If(

Get ( RecordNumber ) - 1 = 0 ; 0 ; n_net_worth - (GetNthRecord ( n_net_worth ; Get ( RecordNumber ) - 1 ))

)