I have a job schedule calendar table, each record is one day of the year.
I use repeating fields which look up data from another table in my database. Basically I can enter a job number and it will add all the relevant information on the repeating field line. It works well.
I am looking to use a calculation repeating field (z_target) which will pull data from another table (z_hours_to_aim_for).
The reason I want to use a calculation field is because the field stays empty unless I re-enter the job number, and I have about a years worth of records. I could make a script to do it but easy if I could just get this calculation to work.
The reason I am using repeating fields is because the database was written a long time ago and I don't have the time to change it.
Currently I have tried this calculation:
R = Get ( CalculationRepetitionNumber ) ;
It adds up the data for all repeating fields and puts it in the first repeating field. Is there a way to change this calculation so that the hours show up in each individual line instead of adding all up in the first repeating field?