I have a number of repeating fields (90) each with a concentration in (Field name = %) (number). I am trying to add an additional repeating field of 90 alongside which is a calculation of some variables. I have created a new field called SED as a calulation and then added the following where '%' is the value in each the repeating field already there and Retention factor and Total Amount applied per day are values from fields in that record. My intention is to calulate a new figure (title- SED) for each of the 90 repeating fields of concentration (%)

Retention factor * Total Amount applied per day*%/6000

This works but I only get the first figure from t eh 1st reaopting field and I need the values for teh remaining 89 but it states 0.

ANy ideas

See if this helps:

http://www.filemaker.com/11help/html/func_ref3.33.39.html#1029496

Thanks I think this is the one but any ideas how I would write it not being an expert!!

Retention factor * Total Amount applied per day*%/6000

Which fields here are repeating and which are not?

I have done one test but I have two non repeating fields and one repeating field so how would I add teh expression as opposed to two rep fioeld s and one non in this example that was given. Almost there...phew!