Wrong colors on Progress Bars

[loewe]

Hi everyone,

I have an issue with the color formatting for Formula Feilds displayed as progress bars, it seems buggy:
With decimal percentages the conditions are not recognized properly, I have the following conditions on a field

but the results are unfortunately wrong for values that are near the "breakpoints".

Any suggestions?

Thanks

[Sho]

Hi @loewe,

I've tried it, seem like color condition apparently can only handle integers.
It is a regret.

[BillH]

Seems like I'm nitpicking, but it's a rounding limitation rather than an integer limitation (49% is actually .49 not 49).  Taking that into consideration, if you can display the percent figure separate from the bar, then adjust the formula for the bar to something like percent-.0049 you should get the desired color.  In the sample below 50% is the cutoff for the color changing from red to yellow, so the original on the left is incorrect, the adjustment on the right is correct.  

[loewe]

Thanks @Sho and @BillH for your reply.

@BillH I'm not sure about how to go to do that. Can you please provide the formula you input in the new field?

My field is a simple x/y operation, formatted as percentage and displayed as bar.

Thanks

[BillH · Accepted solution]

In my sample the formula for the percent field (named percent) is similar, 

Done/Target

For the bar it just 

percent-.0049

[Sho]

I was confused and deleted my earlier post...

I see, so you mean subtract 0.0049
Excellent solution!

[loewe]

Thanks @BillH 

although I must say that'd be better if the field would work as expected instead of implementing this workaround😅

Thanks gain and have a great day

[BillH]

I'm glad it worked.  I agree it would be far better if the field worked correctly, but then again, if everything worked as well as expected a lot of us would be unemployed.

[loewe]

😂