How to read value entered in an inputcontrol of advanced story into the data action advanced formula

[innokeyits]

Hi Experts,

I have a custom story, where some parametets would be entered by the user in a InputField box. for example a number 51.6, and then I need to use this number in the Advanced Formula in a data action. 

I can use slider widget as well. 

How can I do that? The number can be changed while using the story and see the affects of it. 

Thanks in advance,

-SP

[N1kh1l · Accepted solution]

@innokeyits 

Add a slider and configure it as per your needs. You will not be able to use Data Action trigger in this case. So you can use button to trigger the Data Action. I have set the target version as Actuals but you can assign it from input control or dropdown etc. as per your requirement.

Button with script on press

var factor=Slider_1.getValue();
DataAction_1.setParameterValue("Factor",factor);
DataAction_1.setParameterValue("TargetVersion","public.Actual");
if(DataAction_1.execute()){
Application.showMessage(ApplicationMessageType.Success,"DA run succesfully");
Application.refreshData();
}

I also create a parameter in Data Action to accept this slider value.

Simple Advanced Formula

MEMBERSET [d/ZACCOUNT_TEST]="SALARY"
MEMBERSET [d/Date]="202401"

DATA([d/ZACCOUNT_TEST]="SALARYPREV12")=RESULTLOOKUP()*%Factor%

Output:

Br.

Nikhil

[innokeyits · Accepted solution]

Thank you very much, Nikhil. Sorry it took sometime. So, I had to understand that DataAction has to be created and link that to the DataAction_1 script variable of type DataAction. Thanks.