Forum Discussion
Advocate IIError using {[Index]-1} to reference field in previous row
In the first formula you are refering to the field [Margin], which refers to the value in the current row, but you want to refer to the entire table column, so [Margin] must be preceded by the previous step name.
Otherwise, this kind of references tend to be very inefficient, so if you have a large table, the refresh will take "forever".
A far better solution is to get the data from the previous row on the current row, as I explained in this topic.
Community ChampionIn the first formula you are refering to the field [Margin], which refers to the value in the current row, but you want to refer to the entire table column, so [Margin] must be preceded by the previous step name.
Otherwise, this kind of references tend to be very inefficient, so if you have a large table, the refresh will take "forever".
A far better solution is to get the data from the previous row on the current row, as I explained in this topic.
Advocate IIWhat I want to do is refer to the previous row in order to create a cumulative total up to the point when I hit a null value. I was just attempting to figure out how to refer to the previous row data. I'm away from my computer at the moment and will look at your suggestion in detail when I can.
Thanks for assisting.
Regards, Mark.