locked
BI KPI Calculation Problem RRS feed

  • Question

  • KPI calulates target and actual difference using the the following formula Actual-Target/Target. But this is not working with numbers in percentage.  For instance, Actual 2.4% and Target 2%, you will get 2.4%-2% / 2% = 20%.  Is there a formula for numbers in percentage?  It should be 2.4%-2% = 0.4% difference.

     


    • Edited by Mike Walsh FIN Friday, April 8, 2011 7:00 AM Ask one question per thread. Second question removed
    Thursday, April 7, 2011 7:03 PM

Answers