Question:
Hi Friends,
I have a very general question on calculated key figures. I have tried all different options that I know of, but nothing worked. So hope you gurus can help
I need to create a calculated key figure such that it fetches only non zero values of a restricted key figure. Remember I cannot use the boolean operator for not equal to 0 since it fetches only the boolean values 0 or 1 and not the values of the restricted key figure
To be more specific I need something like this
ckf = rkf <> 0
Also if I were to be given the condition that it has to be done in the query designer itself, I was wondering whether it is possible at all.
If someone has done something similar to this before, your suggestions could be quite useful.
Thanks a lot
bwadmirer
Answer:
Can't you just do this:
( NODIM( RKF ) <> 0 ) * NODIM ( RKF )