AnsweredAssumed Answered

Conditional formatting in repeating field - a visual status bar

Question asked by fleng on Jan 7, 2011
Latest reply on Jan 9, 2011 by 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

Outcomes