Conditional Formatting for a text field ValueExpression for durations

[MattYo]

Hi all, 

I am attempting to do some SLA comparison reporting and I am able to do the value expression below but am having trouble applying conditional formatting. GTE 0 then make it green text with green background. LT 0 then make it red text with red background. I have tried taking a standard mode code set and applying it to the text mode but something is not going right. 

descriptionkey=duration
displayname=Actual Duration Variance (Days)
textmode=true
valueexpression=ROUND((((SUB({actualDuration},{duration}))/60)/8),1)
valueformat=HTML

Thanks for the advice!

Matt

[lgaertner · Accepted solution]

Hello Matt,

I am quite sure, that you will not be able to achieve a conditional formatting based on a valueexpression. Instead I would create a custom calculated field, which uses your calculation and is used for the format condition.

Regards

Lars

[MattYo]

Hi Lars, 

That makes sense, I'll take that approach.

Thanks!

Matt