How to replace value in BW report

[Former Member]

Hi Expert,

There is a column in query and it's a key figure, I want to replace it as character description. such as

good replace 1

bad replace 2

something like this. Can I only in WAD using javascript? if so, how to do it? Thanks in advance.

Delve

[sven_mader2 · Accepted solution]

Hi,

How do you know what is "good" or "bad"?

in the calculated keyfigure you can insert a condition like: "( condition )". And multiple the value: "( condition ) * value"

perhaps: "( good condition ) * keyfigure / keyfigure + "( bad condition ) * keyfigure / keyfigure + 1"

Sven

[Former Member · Accepted solution]

Hi

I mean I only use 'good replace 1' for example.

In fact. there are five values for the key figure, 1,2,3,4,5. I want to use five character descriptions instead of them.

[Former Member · Accepted solution]

Hi,

Please check the article:

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/e0b4cfcc-f9c1-2b10-1bb5-d4b61083d471

-Vikram