Skip to Content
0
Former Member
Feb 19, 2009 at 11:24 PM

Comparing key figures when one is not present, or gettng no value to show 0

24 Views

I am using BW 3.5 and trying to make a choice on the use of one of two key figures based on whether one or the other is present. My original idea was to use boolean functions to determine:

ex. [(COUNT(KF1) ) * KF1]+ [(NOT(KF1)) * KF2] would provide result of KF1 if it is present, KF2 if it is not;

However, that only works if both KF1 and KF2 are both present with value of 0; how can I perform the same scenario if KF1 or KF2 is not present at all?