KPI results in " - "

[#1]

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:

Sum(if(BUDGET_MONTH_CAL=MONTH(TODAY()),duration/60)))/if(BUDGET_MONTH_CAL=MONTH(TODAY()), BUDGET_AMT_PROG)

Should I be calculating this percentage?

[#2]

This works, though I'm not clear on why the denominator wants to be summed since it's a single value.

Sum(if(BUDGET_MONTH_CAL=Month(Today()), duration/60))

/

Sum(if(BUDGET_MONTH_CAL=Month(Today()), BUDGET_AMT_PROG))

[#3]

Not it doesn't - I didn't realize I had a filter on.  But it does give me ideas...

[#4]

sum(if(MONTH_ACTUAL_DATE=Month(Today()), duration))/60

/

sum(if(BUDGET_MONTH_CAL=Month(Today()), BUDGET_AMT_PROG))

though I have to tweak it for set analysis