I have a matrix with columns which are dynamically created as the report is run. I need to be able to include for each column after the first one a percentage of the difference between each column and the previous column value.
How do I pick up the value of the previous column for Total Students in order to calculate the remaining percentage.
I've tried Previous but get an error telling me this cannot be used with matrix.
Can anyone help with this.
I found this answer previously. I've never used code before in a report but I did try and use it and kept getting an error to say that there was no value or similar. I think possibly because not all columns have data in them. I was hoping there might be something simpler. I'll try again with the code. Thanks
answered Sep 25, 2012 at 09:32 AM