Conditional formatting in repeating field - a visual status bar
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