cancel
Showing results for 
Search instead for 
Did you mean: 

How to replace value in BW report

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

sven_mader2
Active Contributor
0 Kudos

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
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

It depends on what you are trying to do but you can use Exceptions in query designer. It will not replace values, but it will color cells.

Another option is you can use a formula variable which return values like Good or Bad and you can use this formula variable in a formula for example

value = 1for_var1+value = 2for_var2

I am not very sure about this solution because I dont know how formulas behave when you put a text like "good" but it can be tried.

Regards,

Mustafa

Former Member
0 Kudos

Hi,

I tried to use formula but seems it can't solve this kind of requirement.

No, I can't use exception because it must display character description. I just use 'good replace 1' for example.

I think maybe I have to use javascript in WAD, Can anybody guide how to do it in WAD? Thanks.

Delve

Former Member
0 Kudos

Hi

whether you want to replace the key figure value or u need to create another keyfigure and display this value.

Thanks

Former Member
0 Kudos

I want to replace the key figure value.