Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We are having a requirement were we need to retain a particular value in a measure for calculating rest of the fields, and we are unable to achieve that.
Scenario :
We have a report were we need to calculate a field “growth”. As you can see it is the difference between (month) 2016 and December 2015
Eg: Mar 2016- dec 2015 = 4835-4824 = 11
Month | DEC 2015 | Jan 2016 | Feb 2016 | Mar 2016 | Apr 2016 | May 2016 | Jun 2016 | Jul 2016 | Aug 2016 | Sept 2016 |
Total Count | 4,824 | 4,824 | 4,820 | 4,835 | 4,836 | 4,837 | 4,838 | 4,833 | 4,834 | 4,831 |
Growth | 0 | (4) | 11 | 12 | 13 | 14 | 9 | 10 | 7 |
For this we need to retain the total count of Dec 2015 in an attribute , which we are not able to do. Can you please provide us with the syntax for this.
Try using the inter-record functions like after() and first(): after(count(X))-first(count(X))