I can't find a way to do a Quotient in a new column, like the example in the Table link.
Help with this table Table
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,
Help with this table Table