samcourtenay

Calendar Repeating Field (calculation question)

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

Hello,

 

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:

Let(

R = Get ( CalculationRepetitionNumber ) ;

CustomerDataBase::z_hours_to_aim_for

)

 

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?

Outcomes