I created a custom metric to show a % variance and am having difficulty getting it to display as desired. The 0% variance showing (in my opinion) should be displayed as 100% variance due to there being no budget. My logic is that if there is no budget, then it would be 100% either over or underrun. All of the other calculations are correct so I don't want to mess with those, but I am stuck on how to just adjust these. If this is possible, we would also want the colors to "align" with the numerical variance. For example, if the numerical variance is negative we would want the % variance to show red as well (even if it is at 100% due to it being a 100% overrun) and vice versa for positive variance (black for 100% underrun variance).
For reference, the EAC shown in the table is the Estimate at Completion in the metric properties.
Any ideas would be greatly appreciated, thanks!
You could change the Value Calculation as follows:
=If(Budget=0,1,({Budget}-{Estimate at Completion})/{Budget})
It works in my instance.
Good luck, @Rachel Pearson.
@Guillermo Cuadrado it unfortunately ended up just blowing my numbers out of proportion, but i appreciate you taking the time to assist! my ask is more aesthetic than functionality so as long as the calculations are correct im happy