Question:
Hallo,
is it possible calculate a KF in BEx so as the result is alphanumeric?
Example:
if z_leadtime = 1 then scoring = "ok" else scoring = "no"
At the moment I use a VBA routines in a workbook to get the result.
Thank you very much!
Answer:
read the definition of key figure
this is not possible within the key figure itself... your workaround would be the correct approach for BEx... for Web there is a similar way (you can find a document on SDN)
cheers,
El Belgio
Answer:
we can do using excel funtionality
for eaxmple If z_leadtime value is populated in C5 cell write the below formule in D6 cell
now hide C Coloum;
name the D coloum as z_leadtime or accrdingly
based on values in C coloumn D coloum will give OK or NO
use a formula like wite it in D5 cell
=if((c5) =1,("OK"),("NO"))
KEERTHi
Answer:
Would it be possible to find a work around with the customer exit variables?
I mean, to create a characteristic you would restrict with a variable. This variable would be initialised in the step 3 of the customer exit with the Ok or no according to your criteria and then your key figure would be a restricted one with this characteristic in selection.
Hope it is clear enough.
Cheers,
Cyril.