2 Replies Latest reply: Dec 28, 2017 8:05 PM by Woon Han Yap RSS

    #1 KPI with "SUMPRODUCT" Formula

    Woon Han Yap

      Dear all,

      I would like to create a #1 KPI to show Monthly Average Number as in the blue box in the print screen as well as a Yearly Average Number in the Red Box.

      Print screen.PNG

      Actual calculation formula are as attached in the excel.

       

      Thank you very much in advance for your assistance!

      Cheers and Happy New Year!

       

      訊息由此人編輯:Woon Han Yap