• 5 Subscribers

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.

0 answers in total

Answer this questsion