Aggregation Befre Calculation with Boolean Operator (BW3.5)

[former_member333019]

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.

B.R

Charlie

[former_member189638]

Instead of creating a calculated Key Figure, create a formula in the query and try whether it is giving a desired output??