Quotient (2012-2011) /2011
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?
I found a way to do it by column but not by row.
if (GridValueAt(CurrentRowIndex, currentcolumnindex-2, CurrentSummaryIndex)=0) then 0
(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.