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