on 01-28-2010 12:04 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please check the article:
http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/e0b4cfcc-f9c1-2b10-1bb5-d4b61083d471
-Vikram
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.