Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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 Q1q2q3q4q5q6q7q8q9q10q11
19101112131417190000
158347586141500
Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question