kpi formula in dashboad designer (pps)

• achraf.sp

  Grasshopper

  Points: 11

  More actions

  August 15, 2012 at 9:27 am

  #280266

  Hi

  I want to calculate a rate of evolution of a number over the years, which exists in a SharePoint list with predefined formulas Dashbord Designer and KPI template.

  I created the connection to the list, in this list I have two attribute year of type date and a number

  Example: my SP list:

  Year 2004 2005 2006

  Number 50 35 60

  Result - 30% 71.42%

  I use this formula: [(Cn - Cn-1) / Cn-1] * 100

  I want to have this result: 2004 2005 2006

  - 30% 71.42%

  Problem is that I did not know how to access the attributes Cn-1

  Thanks in advance