4 Replies Latest reply on Apr 26, 2012 9:29 AM by trlewis3

    Repeating Field issue

    trlewis3

      While updating an existing application that displayed a gantt like chart, I ran into an issue. In the orignal version, I used conditional formatting to color the bars in the chart. Then I decided to see if using a containter fiedl would provide better peformance.

       

      The data table has two fields. One is a repeating global date field (cAssignmentGantt). There are 100 repetitions that get populated when the app opens. The other is a repeating calculation field. Here is the calculation:

       

      Case(

      cAssignmentGantt[Get ( CalculationRepetitionNumber )] = Received ; Control::gRed;

      cAssignmentGantt[Get ( CalculationRepetitionNumber )] = Deadline ; Control::gRed;

      cAssignmentGantt[Get ( CalculationRepetitionNumber )] > Received

      and cAssignmentGantt[Get ( CalculationRepetitionNumber )] < Deadline ;

      Control::gGreen;

      )

       

      The calculation only works on the first repetition. Any idea why?

       

      Tom Lewis