Expand my Community achievements bar.

Join us for our Coffee Break Sweepstakes on July 16th! Come ask your questions or share your use cases on Creative Briefs for a chance to win a piece of Workfront swag!

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.