conditional formatting in group footer and report footer

[timISST]

trying to do conditional color font on group footer and report footer. These are average fields. I was able to get the fields in the details to conditional color code the way I would like but have not been able to figure out how to do that in the footers.
This is how I'm doing the formatting in the details section:

if {a}>= '3.5' then crGreen
else
if {a}> '2.5' and {a}< '3.5' then crblue
else crred

 

[IanWaterman]

If report footer

if avg({a})>= '3.5' then crGreen
else
if avg({a})> '2.5' and Avg({a})< '3.5' then crblue
else crred


If group footer
if avg({a}, {groupfield})>= '3.5' then crGreen
else
if avg({a}, {groupfield})> '2.5' and Avg({a}, {groupfield})< '3.5' then crblue
else crred


Not sure if Avg() is the correct funtion if not try average()

Ian

 

[lbass]

Remove the quotes around the numbers if these are averages and use average() as Ian suggests.

-LB