on 12-19-2017 1:13 PM
I have a report that has two parameters (years) and if a user selects, for example, 2013 - 2015, then I have to make the report generate the yearly difference in each year. Since the only parameters are the begin year and end year, I have to do something for the middle year. The parameters are strings and when I try this to get the middle year, I get the "gridvalueat is out of range" error. The formula I'm using is:
GridValueAt(CurrentRowIndex, GetColumnPathIndexOf({?year2}), CurrentSummaryIndex) - GridValueAt(CurrentRowIndex, GetColumnPathIndexOf( Totext(tonumber({?year2}) - 1 ) ), CurrentSummaryIndex)
It's the GetColumnPathIndexOf( Totext(tonumber({?year2}) - 1 ) ) that's causing the error... Help, please?
Hi Kenshin,
Could you also attach a screenshot of where the difference columns have been inserted for each year in the Crosstab?
-Abhilash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.