Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Text Mode help please

Avatar

Level 3

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

2 Replies

Avatar

Community Advisor

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. 

 

Avatar

Level 3

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