Question:
Hi All,
I can't find any solution all over the topics so I post a new question on the endless topic the key figures...
I calculate some percentages and the client would like to replace all the 0% by a 100%. I took into account this request and changed the query option "Show zero as" and I manually entered '100%'. But the point is that charts are attached to the query result and it takes into account the 0 value and not the displayed value.
Is there any way to change (in the customer exit for instance, or another abap program) this 0% value according to a test result?
I mean: if % = 0 and nbr = 0 then % <- 100.
the nbr is another key figure I would like to take into account.
Thanks a lot budies,
Cheers,
Cyril.
Answer:
creeate another kf altogether which logic which says, if the other kf is 0 then this kf is 100
then report on the new kf and hide the old one.
or you could change this directly at the source using rules&formula's
rgards
Answer:
thanks for your answer.
I forgot to mention that these percentages are calculated when the query runs. Not when the cube is filling in. I write this because as far as I can remember the tests are not possible when you calculate the value of a key figure during the query calculation.
thanks a lot.
Answer:
ok some news...
I have found the following help topic in the sap help.
http://help.sap.com/saphelp_nw04/helpdata/en/81/b54aa832e911d4b2c10050dadfb23f/content.htm
the point is that I tried to get a look at the function module UPF_MODIFY_KEY_FIGURE in order to see how to use the exit function but I am not able to see if I can use it with a customer exit and I am not able to find out how to use this exit function.
has anybody already used this kind of exit function? If so, can you please give me some additional information concerning the way of changing the key figure I want to change.
Answer:
ok I change the shape of my question: is there any program in SAP that runs after the data is collected to present the data in the workbook that would allow me to have access to all the data set?
Answer:
got it !!!
I was not aware on how to perform a test in the formula. This is quite weird.
In fact, I have done a test multiplied by 100.
((ratio calcul) == 0) * 100
In fact, when the value of the (ratio calcul) is equal to 0 the return value of the test is 1 and I multiply (in fact it is a logical and) by 100 and the return value is 100. To get a % I just add to this formula %A 100.
pfiou ... what a weird way of doing tests....
Cheers,
Cyril.