Expand my Community achievements bar.

SOLVED

Conditional Formatting for a text field ValueExpression for durations

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

2 Replies

Avatar

Correct answer by
Level 10

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

Avatar

Level 1

Hi Lars, 

 

That makes sense, I'll take that approach.

 

Thanks!

Matt