Bex formula for copying last non zero value from column set into another column
can anyone help me with implementing one condition.
I have some colums in BEX as this.
I want to copy the last non-zero value from this q() colums into the total column by using bex formula.i can use if else condition type for this but it becomes really big. in future there may be need to increase the colums also.
or is there any other way to implement it by using planning functions ?
please share ur answers.