Percentage Completion - Ideas to improve

[CR85user]

Hi Folks,

Could I ask for any ideas to improve the formulae I use currently to display a completed percentage.

I have a percentage value - call it {@Completed} example values:
10
45
67
99
100

I then have a formula referencing this to display a proportionate value - call this {@growth}

//Completed percentile based on scoring
if {@Completed} <= 101 then replicatestring('|',12+{@Completed}) else ''

This is simply a check that the percentile is within the correct constraints and then to display a relevant width of the field. The +12 is to allow spacing for the percentile value itself to be placed in bold on top of the field.

I then place this field on the detail line and format the field as follows:
Border -> Tight Horizontal (Ticked)
Border -> Background (Ticked) X+2 Formula as follows:

color(255-{@Completed}*2,{@Completed}*2,0)

Font -> Color (Ticked) X+2 Formula as above:

color(255-{@Completed}*2,{@Completed}*2,0)

This then ranges the background and text colours to show a red colour for low percentiles up to green for completed. The middle ranges however are a pretty muddy brown rather than orange as such.

Any ideas How I can tweak this a little to show a more suitable range of fading colours?

Any help would be appreciated.

'J