Conditional formatting does not work on a field that has an Average

[Former Member]

Hello All,

I have a field called "Productivity" on which i have applied conditional formatting by right clicking on that field and going to "Format Field ", "Font" tab and clicking on the formula next to the "Color" field.

I have the following formula for this field:

"If {@Productivity} < 95 then crYellow Else If ({@Productivity} >= 95 And {@Productivity} < 97.99) Then crBlue Else If {@Productivity} >= 98 Then crGreen"

I have also created an Average of this field and placed in the Group footer and I am trying to apply the same conditional formatting on this Average by using this formula:

"If Average ({@Productivity}) < 95 then crYellow Else If ((Average ({@Productivity}) >= 95) And (Average ({@Productivity})) < 97.99) Then crBlue Else If (Average ({@Productivity}) >= 98) Then crGreen"

However, this formula does not apply the correct formatting and does not change the color of the fields.

Any clue on why this formatting does not work on the "Average" of this field?

Any help is greatly appreciated.

[abhilash_kumar · Accepted solution]

Hi Nimish,

Use:

If CurrentFieldValue < 95 then crYellow Else If ((CurrentFieldValue) >= 95) And (CurrentFieldValue) < 97.99) Then crBlue Else If (CurrentFieldValue >= 98) Then crGreen

-Abhilash

[Former Member · Accepted solution]

Thanks, this formula worked well.