Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to have two colomns where in each lines i have the value of year N (in first field) and year N-1 (in second field).
For a better understanding here is an exemple:
Year | Net Year N | Net Year N-1 |
---|---|---|
2013 | 9 | |
2014 | 14 | 9 |
2015 | 10 | 14 |
2016 | 17 | 10 |
2017 | 25 | 17 |
I used the following expression:
Sum({<Year={"$(=(Year(AddYears(Date('01/01/'& Year),-1))))"}>}TOTAL [Net])
But the problem is that it work only when i select value in colmn "year"
thank you.
Try these two expression
Net Year N
Sum(Net)
Net Year N-1
Above(Sum({<Year>} Net)) * Avg(1)
Or use The As-Of Table