I am trying to set a conditional coloring for my pivot. I want to calculate the current availability of our service.
I have a table containing all the event of downtine with the last column that takes the specific target (contractual) availability precentage for each service (using LOOKUP function):
The pivot takes the same table as a source and is doing a simple calculation:
Current availability. % = IF([Total DownTime]=0, 1, (1-([Total Downtime])/[Max q_seconds in current quarter]))
I am tryuing to set red color on the values that are lower than the target and green for the OK ones. I am doing this with selecting the Target value for each service with MAX(Target_availability):
and here is the issue I ahve - I got green color all rows, even for the ones that have their value lower than the target:
Please sign in to leave a comment.