Macro having % addition

[Former Member]

Hi Experts,

We have special requirement for calcluating the weighted demand for different key figures in plannnig book.

the secnario is as below -

Row 1 - Forecast input

Row 2 - Macro should be such that, row 2 = X% higher than row 1.

now, this X% should be changable as per planners requirement.

e.g.

Row 1 = 100

planner wants to give weight of 10% to row 1, then,

Row 2 = 110 i.e. 1.1 (10% high than first row) * first row.

in this case also, the planner should have to change the % weight.

Does this scenario is possible using Macro?

Any inputs are highly appreciated in this case.

Thanks in advance for looking into it!

rgds/Jay

[Former Member]

Hi Jay,

This can be mapped using a macro. For this you would need to have an additionl KF defined, lets say"% manual input" then

row1 Fcst

row2 % manual input

row3 result

You may put the below condition to achieve your result:

row3=

if

row2< =0

then

row3=r1

else

row1+(row2*100/row1)

Thanks,Bopanna