Bex formula for copying last non zero value from column set into another column

Hi,

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.

total Q1 q2 q3 q4 q5 q6 q7 q8 q9 q10 q11 19 10 11 12 13 14 17 19 0 0 0 0 15 8 3 4 7 5 8 6 14 15 0 0