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.