Skip to Content

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

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 (14426 B)
Former Member
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question