Text Mode help please

[ajdifonzo]

Hi Y'all, 

I'm working on having a column that shows the % of the actual cost to the planned cost and have anything over 80% highlighted.  I have the text below, but it's highlighting all values.  

displayname=% of Planned Cost
linkedname=direct
namekey=plannedCost
querysort=plannedCost
styledef.case.0.comparison.icon=false
styledef.case.0.comparison.leftmethod=plannedCost
styledef.case.0.comparison.lefttext=plannedCost
styledef.case.0.comparison.operator=gt
styledef.case.0.comparison.operatortype=double
styledef.case.0.comparison.righttext=80.00
styledef.case.0.comparison.trueproperty.0.name=bgcolor
styledef.case.0.comparison.trueproperty.0.value=eac6c9
styledef.case.0.comparison.truetext=
textmode=true
valueexpression=({plannedCost}-{actualCost})/{plannedCost}*100
valueformat=doubleAsPercentRounded

[Richard_Le_]

Hi,

It's not possible to set conditional formatting on a value expression built in a report view. These calculations are carried out in the report only and as such there is no value in the workfront database to compare against for conditional formatting.

The way to achieve this would be to have a calculated custom field on the object you are reporting on, that calculates the % of planned cost. You can then build conditional formatting against this custom field as desired.

Best Regards,

Rich. 

[ajdifonzo]

Thanks Rich.  I had a feeling that was going to be the answer.