Skip to Content
avatar image
Former Member

Displaying "Results" in all the results rows

Hello experts,

I have a bit of a challenge here; in my BEx report I would like to know if is possible to have the word "Result" written in all the yellow cells that represent the results rows, see attached image.

Could you please giveme your advice?

Thanks for your kind support.

Indi

results.png (14.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 06, 2015 at 04:47 PM

    Hi Indi,

    Since your report output is excel, so you need to write VB Macros to fill the "Result".

    Use below formulas.

    cell.isblank() = TRUE and cell(color) = "YELLOW" then write "Result".

    May be use below links for coding.

    BW-BEX-ET-WB-7X - 7.x Analyzer Frontend - SAP NetWeaver Business Warehouse - SCN Wiki

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 07, 2015 at 07:48 AM

    Thank you very much Nanda, it works! 😉

    Add comment
    10|10000 characters needed characters exceeded