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?