Setting Year parameter to Data Action based on input control MMYYYY

[mayiya]

Hi experts. 

In my story I have a Forecast layout table with an calculation input control for cut-over date. 

I have a Data_Action_1 which needs as parameter: 1.The result of the calculation input control . Why input control is not shown on selection options?

2. Year. This should be the same year as for calculation input control. For example if calculation input control is: Aug, 2023, then Year= 2023; if calculation input control is: Nov, 2024 , then Year=2024. 

Actually,  Data_Action_1 shows prompts for: calculation input control (Fecha Inicio Proyección) and year (Año Proyeccion). 

How can I pass year from calculation input control (Fecha Inicio Proyeccion) to Year parameter  (Año Proyeccion) ?

Thanks , please help!!

[N1kh1l]

@mayiya 

Fecha Inicio Proyección This one can be set using the Input control. make sure the parameter is set as below

Also the formula input control should return Date format of SAC which is YYYYMM. 

For Año Proyeccion you can set it with an input control which returns YYYY

Alternatively you can use scripting to set the parameter values on a button click and then set it to execute. In scripting you have more control to manipulate the string parameters.

Br.

Nikhil

[mayiya]

Hi Nikhil.

Fecha Inicio Proyeccion is already configured as you said: 

But in the story the calculation input control is not recognized. Maybe because it is a calculation input control? T his calculation input control is created when using forecast layout table.

As for the Year parameter it is configured as:

I need to use the year parameter because on my data action I need the 12 months of the year, I tried using MEMBERSET [d/Date]= FIRST(%FechaInicioProyeccion%) to LAST(%FechaInicioProyeccion%), but it gives me the error of "Not viable alternative at input 'FIRST' ".  

I'm searching for blogs/info about passing parameter to data action by scripting, but without success. It gives me the error:

[mayiya]

Please any advice or workaround for these? Actually on every data action the Fecha Inicio Proyeccion and Year is as prompt, but this parameters are used in all data actions, so is very bad that users enters the same parameters on story.