Skip to Content
0
Oct 15, 2009 at 12:17 PM

BEx Query Designer - % CKF

40 Views

Hello all,

I need to create a new Calculated KF, the scenario is somewhat like this

sold Products%: 10%, 0%, 40%, 30%, 20% = 100%

revenue: 100, 0, 400, 300, 200 = 1000

what would be the formula to make this new 'sold products %' KF

Secondly, for some products there are value '0' and those are not shown in BEx analyzer. What is the property that needs to be changed so that even values are '0' but they are shown.

thanks

Ahmad