Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jul 21, 2016 at 02:56 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.