Skip to Content
avatar image
Former Member

Macro having % addition

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Mar 01, 2010 at 09:13 AM

    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

    Add comment
    10|10000 characters needed characters exceeded