Skip to Content
avatar image
Former Member

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
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 29, 2014 at 09:38 AM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 29, 2014 at 10:14 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Sucheta,

      this Q() represents the selections .

      Can i  use the VB code in WAD ??

      Thanks ,

      Rakesh.