| Group | years | Jan | Feb | Mar | APr | May | Quotient |
| conditioner | 2010 | 2 | 2 | 2 | 2 | 8 |
|
| conditioner | 2011 | 3 | 3 | 3 | 3 | 12 | Quotient (2011-2010) /2010 |
| conditioner | 2012 | 4 | 4 | 4 | 4 | 16 | Quotient (2012-2011) /2011 |
| Shampoo | 2010 | 2 | 2 | 2 | 2 | 8 |
|
| Shampoo | 2011 | 3 | 3 | 3 | 3 | 12 | Quotient (2011-2010) /2010 |
| Shampoo | 2012 | 4 | 4 | 4 | 4 | 16 | Quotient (2012-2011) /2011 |
| Cream | 2010 | 2 | 2 | 2 | 2 | 8 |
|
| Cream | 2011 | 3 | 3 | 3 | 3 | 12 | Quotient (2011-2010) / 2010 |
| Cream | 2012 | 4 | 4 | 4 | 4 | 16 | Quotient (2012-2011) / 2011 |
I can't find a way to do a Quotient in a new column, like the example above.
Can someone advice?
FYI
I found a way to do it by column but not by row.
if (GridValueAt(CurrentRowIndex, currentcolumnindex-2, CurrentSummaryIndex)=0) then 0
Else
(GridValueAt(CurrentRowIndex, currentcolumnindex-1, CurrentSummaryIndex)/GridValueAt(CurrentRowIndex, currentcolumnindex-2, CurrentSummaryIndex)-1)*100
if I do this
if (GridValueAt(CurrentRowIndex-1 (or +1), currentcolumnindex, CurrentSummaryIndex)=0) then 0
it gives me an error : "Argument #1 of 'GridValueAt' is out of range"
If you have a better I will love to hear it.
Thanks,
Heli
