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
Solved! Go to Solution.
Views
Replies
Total Likes
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
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
Hi Lars,
That makes sense, I'll take that approach.
Thanks!
Matt
Views
Replies
Total Likes
Views
Likes
Replies