Skip to Content
Dec 24, 2007 at 07:47 AM

Aggregation Befre Calculation with Boolean Operator (BW3.5)


Dear All,

Here I am trying to create a 'Calculated Key Figure' with some logical expression to verify the value of other columns(ie: stock value = 0, market value = 0...etc) and I would like to calculate the result 'Before Aggregation'; Somehow, the calculated key figure with Boolean Operator can not be chosen as 'Before Aggregation'. I tried to create 2nd CKF to include the 1st CKF so that I am able to select the 2nd CKF as 'Before Aggregation', but the result just dont seem to be right.

Any Idea to do this kinda calculation? Thanks a lot.