Conditional Formatting for a text field ValueExpression for durations | Community
Skip to main content
M
MatthewYo3
New Participant
February 1, 2024
Solved

Conditional Formatting for a text field ValueExpression for durations

  • February 1, 2024
  • 1 reply
  • 565 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by 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

1 reply

lgaertner
lgaertnerAccepted solution
New Participant
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

    M
    MatthewYo3Author
    New Participant
    February 9, 2024

    Hi Lars, 

     

    That makes sense, I'll take that approach.

     

    Thanks!

    Matt

    Terms & ConditionsAccessibility statement

    Loading footer...