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 IIHi Marcel
Thanks for pointing me in the right direction and taking me away from going down the path of using {[Index]-1}.
I tried out that option ans as you pointed out, it results in a very long query execution time (I just killed the process after it had taken way to long already).
I actually already had the 2 indexes and had done the merge, so thinking about it I used groupings to solve my problem of summing the [Margin] column.
Many thanks for assisting and best regards, Mark.