9 Replies Latest reply: Mar 29, 2017 7:26 AM by omar bensalem RSS

    How do I create a KPI for Win/Loss ratio?

    Oliver Clarke

      Hi All

       

      I have a set of projects, some won, some lost, some discontinued and some in process.

       

      What I need is a ratio of projects WON versus projects LOST or DISCONTINUED.

       

      My data looks like this...

        

      Project IDStatusValue
      87645won3500.00
      67542won5000.00
      76547lost10000.00
      96765discontinued30000.00
      54362lost2500.00
      45364won15000.00
      95637in process40000.00

       

      I need an expression for a KPI in the dashboard that sums up the WON, LOST, and DISCONTINUED, and then calculates the ration.

       

      In excel I can do this with the SUMIF function. 

       

      Any help would be much appreciated.

       

      Thanks!