I'm trying to calculate the percentage hours toward monthly goal. Separately, I've confirmed that my numerator and denominator give me the desired results, but when I try to divide the numerator by the denominator, I get " - " in my KPI. The calculation is:
Should I be calculating this percentage?
try like this?
Note: Make sure BUDGET_MONTH_CAL should have numeric value as Month() will return 1,2,3,4 etc
Hi Balraj - No luck with that. One thing I did just test is if I entered the actual value for the denominator vs. the calculated numerator and vice versa.
If I enter the actual numerator and calc the denominator, I get "-".
If I calc the numerator and enter the actual denominator, I get the desired results.
Not sure if that means anything.