Macros can Variables be populated by Row cell values?

[former_member584840]

I am trying to put a value from a Key figure value into a variable to use it in a calculation to populate a different key figure.

This does not seem to work for me.

I can only populate values by a popup box. eg

GET POPUP VALUE

LAYOUTVARIABLE_SET( 'X' ;

NUM_VALUES_INPUT( 'enter_percentage_value' ;

'CAPACITY_PERCENTAGE_TARGET' )

)

And then I can use a MANUALLY entered value, but I cannot populate a number from a key figure into the Variable.

I am actually trying to grab a value from the top SNP screen and use it in the bottom SNP screen.

Is this simply not possible? ie can VARIABLES only be set by a manual popup box?

Thanks!

J

[Former Member · Accepted solution]

Hi,

Use LAYOUTVARIABLE_SET to assign a value, and LAYOUTVAR_VALUE to recover it (ie. to a kf, popup or to a new value). LAYOUTVARIABLE would work for strings.

This would copy values from the "Delta" KF to the "Original forecast" by saving them first to the variable and then copying. Try something like this.

Thanks

J.

[former_member584840 · Accepted solution]

Thanks James. Not sure what I was doing wrong in the half dozen ways I had tried before, but I tried again and it worked this time. Much appreciated!