AnsweredAssumed Answered

Repeating field calculation problem

Question asked by cmayerle on Apr 23, 2016
Latest reply on Sep 16, 2016 by cmayerle

I'm having problem with the following repeating field that is supposed to get a text field (MSN_full_related::msn_mission_number) from a cartesian related record based on a calendar start date:

 

Let(eval_date=Extend(cal_start_date)+Get(CalculationRepetitionNumber);


If(

eval_date > Extend (MSN_full_related::msn_dep_day)

and

eval_date < Extend(MSN_full_related::msn_return_day) + 2;


Extend(MSN_full_related::msn_mission_number)))


Precisely, the calculation will only return the value on the first record that was created, which is usually not the first repetition.  If the date range of the first created record goes for several repetitions, it will fill in each repetition.  It just won't evaluate records other than the first created one.  None of the date ranges overlap.

 

Any help would be appreciated.

 

Thanks,

Chris

Outcomes