Conditional Formatting for a text field ValueExpression for durations | Adobe Higher Education
Skip to main content
New Member
February 1, 2024
Beantwortet

Conditional Formatting for a text field ValueExpression for durations

  • February 1, 2024
  • 2 Antworten
  • 593 Ansichten

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

Dieses Thema wurde für Antworten geschlossen.
Beste Antwort von lgaertner

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

2 Antworten

lgaertner
lgaertnerAntwort
Level 9
February 2, 2024

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

New Member
February 9, 2024

Hi Lars, 

 

That makes sense, I'll take that approach.

 

Thanks!

Matt