Displaying "Results" in all the results rows

[Former Member]

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

[ccc_ccc · Accepted solution]

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

[Former Member]

Thank you very much Nanda, it works!