Skip to Content

Macros can Variables be populated by Row cell values?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Dec 13, 2012 at 07:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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!