Skip to Content

Can any body please expain the below macro?

Hello Expert,

Could you please help me in understanding the below macro how it is calculating the values.




capture.png (17.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Jun 16, 2017 at 06:39 PM

    Hello Jeet,
    Below the explanation about the macros functions that are being used:

    • LAYOUTVARIABLE_SET( 'my_Variable' ; value)
      my_Variable = Name of variables
      Value = numeric value
      'Value' = alphanumeric character string
      Description: LAYOUTVARIABLE_SET() assigns the numeric value or the alphanumeric character string 'value' to the variable my_Variable . If you want to assign an alphanumeric character string, you set the argument in single inverted commas, that is, 'value'. If you want to assign a numeric value, you use the argument without single inverted commas. You can access the variable my_Variable with the functions LAYOUTVAR_VALUE () and LAYOUTVARIABLE () in other macros of the same planning book. The content of the variables is deleted when new data is loaded into interactive planning. The declaration of the type of variables (numeric or alphanumeric) takes place automatically when setting the variables with LAYOUTVARIABLE_SET ().

    • LAYOUTVAR_VALUE( 'my_Variable' )
      my_Variable = Name of variables
      Description: LAYOUTVAR_VALUE () returns the value of the numeric variables my_Variable. You must assign this value to the variables first with the function LAYOUTVARIABLE_SET ().

    More info at:

    Best regards,
    Werner Hansen

    Add comment
    10|10000 characters needed characters exceeded