Help needed in Macro

[Former Member]

Hello Experts,

I am creating a macro, where the requirement is; user would select few columns of a KF & hit on a macro.

The values in the KF should get multiplied by 2.

Any clue how should I add ( *2) functionality in operation / function ?. Any other suggestion is welcomed.

Please help

Regards

Rahul Chitte

[Former Member]

Thank you. It Works !

[former_member220487]

Hi Rahul,

You can set the macro to run for few period.

1) In the step of the macro, select the period you want to run

2) Within the step, Results row (Key figure row 'XXX") = Key figure row 'XXX" * 2 (remember to maintain a space between * and 2)

3) Check the macro for any error, which would help you for any inconsistencies

4) activate the macro to test your requirement.

hope this would solve your requirment.

Regards,

Nawanit