13 Replies Latest reply: Jan 12, 2016 9:52 AM by Maryjane Black RSS

    KPI results in " - "

    Maryjane Black

      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?