Calendar Repeating Field (calculation question)

Discussion created by samcourtenay on Sep 13, 2015
Latest reply on Sep 16, 2015 by samcourtenay



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?