For my SNP planning book, I have a requiredment to add multiple vector areas in a vector variable using vec_layoutvariable_app() function. I belive this macro function appends area key figures into vector like a two dimentional data. For instance I am going to use:
Action: Attach values to my_vector variable for a group of Products in the planning table
Step 1: Append group totals
VEC_LAYOUTVARIABLE_APP( ‘MY_VECTOR’ ;
Area: [ $Sales Order ( INITIAL ) ; $Sales Order ( M 12/2014 ) ]
This will generate a vector variable MY_VECTOR which have values like:
But I do not know how to read this and assing to a Area: Key figure. If I use layoutvariable as shown below:
Area: Total Demand (Forecast/Sales Order) ( INITIAL ) =
VEC_LAYOUTVARIABLE( ‘MY_VECTOR’ )
The above laoutvariable reads only the first row value.
I want to all three rows added and assign to Total Demand Key figure like:
Any idea on this? Appreciate your time and thanks in advance.