In Crystal Reports 14.0.9 I have a Crosstab report that details the sales for each product over two years. I have a total for the two years, but what I really need is the difference between the two. I have built an Embedded Summary with the following:
GridValueAt (CurrentRowIndex,(CurrentColumnIndex - 2) , 0) - GridValueAt (CurrentRowIndex,(CurrentColumnIndex - 1), 0)
I want it to take the two rows prior and subtract one from the other. I get:
Argument #2 of 'GridValueAt' is out of range.
I have tried using a variable in place of the math inside the GridValueAt function.