Conditional Formatting Based on Calculation

Question

Hello Planview Community,Could use some advice on how best to implement conditional formatting for a report based on calculations. Context: I’ve got a report that shows the calculated resource Billability % and each resource has their own billability targets (Target Utilization % Field). Inquiry: How do I set conditional formatting in the table so that the text is red if the calculated Billability % is less than the individual resource’s Target Utilization %?  I’ve tried going into the advanced settings for the conditional formatting but can’t seem to find the Target Utilization field that’s configured to Users. Many thanks!

Andy Johnston · Accepted Answer

I’ve found in the past with complex calculations, and both Conditional Formatting, or display calculations, or workflow rules I try to work out the calculation in a calculated field first. So I end up with a field that is something like “FieldXYZ_DisplayCondition” - and I try to have the output of that as a simple number, like 1, 2, 3 which I map to the colour when I do the conditional formatting.eg. in the conditional formatting logic it might be:if FieldXYZ_DisplayCondition = 1 then colour = green, if 2 colour = amber, else red.If you do it this way - and you want to make a change to conditional formatting ANYWHERE in the system, then you only have to change ONE formula in the calculated field, and ALL the conditional formatting in all the views will change.In this specific example though - you’ve talked about a value based on User? Is the target and billability both based on the User object? That might still be able to work - but I’m not sure there’s a “currently logged in user” ability in calculated fields to pick up whoever is logged in if that’s what you need to do?

Planview Customer Community

Login with SSO

Planview Customer Community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded