2 Replies Latest reply on Jan 9, 2011 6:23 AM by fleng

    Conditional formatting in repeating field - a visual status bar

    fleng

      Title

      Conditional formatting in repeating field - a visual status bar

      Post

      Hi,

      I'm trying to build a visual status bar that visually shows me the current percentage done for a given task.

      The field Percentage is a drop down with the choices 10, 20, 30 ... 100 (the number in orange on the image)

      I have made a calculation field with 10 repetitions (Named "VisualStatus") with the following calculation:

       If (Get (CalculationRepetitionNumber) <= Percentage ; 1; 0)      it's set to return a number value.

      Then in the layout I've set the conditinal formatting of the repeating field (VisualStatus) to 

      Value is equal to 1

      Color the field green.

      It doesn't work. It only returns 1 for the first repeating field and then nothing in the rest.

      Pls. help anyone

      Soren

      Sk%C3%A6rmbillede_2011-01-07_kl._16.48.05.png