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

[Former Member]

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

[former_member194898 · Accepted solution]

Hi,

As far as I know it's impossible.

You can display data in quarters (year by year)

then I would use simple VB code to assess last non zero value in rows.

Regards, Leszek

[Former Member · Accepted solution]

Hi Leszek,

Thank you for your solution.

Can i use this VB coded workbook or analysis grid from bex analyser  in WAD .

Thanks,

Rakesh.

[former_member194898 · Accepted solution]

Hi,

I use VB coding in BEx Analyzer.

You can find my way of attaching VB code to a workbook here .

Regards, Leszek

[Former Member]

Hi,

If q( ) repesents the infoobject then use aggregation LAST. If they are different KFs use Customer Exit formula variable or use nested formula with * or +. or as per suggestion given by Leszek use VB Code.

Regards,

Sucheta

[Former Member]

Hi Sucheta,

this Q() represents the selections .

Can i  use the VB code in WAD ??

Thanks ,

Rakesh.