cancel
Showing results for 
Search instead for 
Did you mean: 

Error during script processing. Contact the Application Designer to resolve the issue

Former Member
0 Kudos

hi every one.

i am facing "Error during script processing. Contact the Application Designer to resolve the issue" error while i am creating a planning template.

there are other 100+ error messages which are saying that "No matching data found in getData("EID", {}).".

i have checked with BW team and data is coming properly in analyser .

i have tried many permutations for this but getting no result.

please help me out.

PFA the screenshot.

Br/Mohit

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi Guys ,

The issue is resolved now. I did few changes in “initial view” for each data source. Actually the KPI’s which are present in the Prompt need to be removed from the “ROWS” portion and after that data is coming proper in design studio, according to the Bex Analyser output.

Anyways thanks for your help and time. I appreciate.

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos
Former Member
0 Kudos

Tammy,

i have gone through these links but still no benefit.

I am sharing further details:

the layout is such that, i am using 4 grids (with 20*10 Rows and Columns). not each box is filled with "Input field". SO i am having around 500+ Input Field.

I am using 13 different Bex queries i.e. 13 data sources in design studio.

also i have done many calculations using "VAR".

I am sharing the script and layout for better understanding.

now  very few "getdata" and "getdatastring" are working but not all.

DS_1.loadDataSource();

DS_4.loadDataSource();

DS_3.loadDataSource();

DS_2.loadDataSource();

DS_5.loadDataSource();

DS_6.loadDataSource();

DS_7.loadDataSource();

DS_8.loadDataSource();

DS_9.loadDataSource();

DS_10.loadDataSource();

DS_11.loadDataSource();

DS_12.loadDataSource();

DS_13.loadDataSource();

//FOR HEADERS

//calculation previous year

var Year = (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));

var Year1 = Convert.stringToFloat(Year);

var LastYear = Year1-1;

//Last year same month

TEXT_11.setText((Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),0,3)) + " "+LastYear);

TEXT_18.setText((DS_1.getVariableValueText("ZCAL_MONTH1"))+"\n" +" Target");

//calculation month from prompt

var monthNum= Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),0,3);

var month = "";

if (monthNum == "JAN") {month = ("DEC " +(LastYear));} 

else if (monthNum == "FEB") {month= "JAN " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "MAR") {month= "FEB " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "APR") {month= "MAR " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));} 

else if (monthNum == "MAY") {month= "APR " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "JUN") {month= "MAY " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "JUL") {month= "JUN " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));} 

else if (monthNum == "AUG") {month= "JUL " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "SEP") {month= "AUG " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "OCT") {month= "SEP " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "NOV") {month= "OCT " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

else if (monthNum == "DEC") {month= "NOV " + (Convert.subString(DS_1.getVariableValueText("ZCAL_MONTH1"),4));}

TEXT_15.setText(month + "\n" +" Target"); 

TEXT_16.setText(month + "\n" +" Actual");

//CALCULATION

/*

var a1 = DS_7.getData("62WHY1EOAR5NU7ONHVUULUIVS", {}).value/10;

var a2 = DS_5.getData("62WHY1EOAR5PKI4GH00XNR240", {}).value/10;

var a3 = (a2/a1)*100;

TEXT_78.setText(Convert.floatToString(a3));

INPUTFIELD_199.setValue(Convert.floatToString(a3,"#0.00")+"%");

*/

//Total Revenue Generated (Lacs) (Total Secondary Sales) (Lubes + Parts)

//INPUTFIELD_34.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_33.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_2.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKIRYAV1E3VJAO", {}));

//INPUTFIELD_47.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_13.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_65.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKIRYAV1DN5AB4", {}));

//INPUTFIELD_56.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_84.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_74.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKIRYAV1E955YO", {}));

//Total Spares Revenue (Lacs) Primary (Inbound Delivery + GRN)

//INPUTFIELD_11.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_35.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_21.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_48.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_22.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_66.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_57.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_85.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_75.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//spares revenue secondary-dealer

INPUTFIELD_17.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01XPJHO2", {}));

INPUTFIELD_31.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01XJN19U", {}));

INPUTFIELD_18.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD215H6V", {}));

INPUTFIELD_49.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01XUM3HU", {}));

var T46 = DS_13.getData("62WHY1EOAR5NU7MQBYD215H6V", {}).value/10;

var A46 = DS_1.getData("62WHY1EOAR5NU3ZXD01XUM3HU", {}).value/10;

if (Convert.floatToString(A46,"#0.00") == '0.00') {INPUTFIELD_46.setValue("0%");}

else if  (Convert.floatToString(A46,"#0.00") != '0.00') {var P46 = (A46/T46)*100;INPUTFIELD_46.setValue(Convert.floatToString(P46,"#0.00")+"%");}

//INPUTFIELD_46.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_67.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD1LHUTJ", {}));

INPUTFIELD_58.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQS65BAO", {}));

var T86 = DS_13.getData("62WHY1EOAR5NU7MQBYD1LHUTJ", {}).value/10;

var A86 = DS_1.getData("62WHY1EOAR5PKEC80OQS65BAO", {}).value/10;

if (Convert.floatToString(A86,"#0.00") == '0.00') {INPUTFIELD_86.setValue("0%");}

else if  (Convert.floatToString(A86,"#0.00") != '0.00') {var P86 = (A86/T86)*100;INPUTFIELD_86.setValue(Convert.floatToString(P86,"#0.00")+"%");}

//INPUTFIELD_86.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_76.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD269U87", {}));

//spares revenue secondary-retail

INPUTFIELD_9.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01Y9S5RM", {}));

INPUTFIELD_27.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01Y4PJXU", {}));

INPUTFIELD_20.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD2QRADJ", {}));

INPUTFIELD_50.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01YER96A", {}));

var T55 = DS_13.getData("62WHY1EOAR5NU7MQBYD2QRADJ", {}).value/10;

var A55 = DS_1.getData("62WHY1EOAR5NU3ZXD01YER96A", {}).value/10;

if (Convert.floatToString(A55,"#0.00") == '0.00') {INPUTFIELD_55.setValue("0%");}

else if  (Convert.floatToString(A55,"#0.00") != '0.00') {var P55 = (A55/T55)*100;INPUTFIELD_55.setValue(Convert.floatToString(P55,"#0.00")+"%");}

//INPUTFIELD_55.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_68.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD2BFYH3", {}));

INPUTFIELD_59.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQSBNQ0G", {}));

var T87 = DS_13.getData("62WHY1EOAR5NU7MQBYD1LHUTJ", {}).value/10;

var A87 = DS_1.getData("62WHY1EOAR5PKEC80OQSBNQ0G", {}).value/10;

if (Convert.floatToString(A87,"#0.00") == '0.00') {INPUTFIELD_87.setValue("0%");}

else if  (Convert.floatToString(A87,"#0.00") != '0.00') {var P87 = (A87/T87)*100;INPUTFIELD_87.setValue(Convert.floatToString(P87,"#0.00")+"%");}

//INPUTFIELD_87.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_77.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD2VTW7B", {}));

//spares revenue secondary

INPUTFIELD_7.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9MY34UE", {}));

INPUTFIELD_29.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01YOSYEQ", {}));

INPUTFIELD_42.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCU9AIX3", {}));

INPUTFIELD_51.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9N3UBLY", {}));

var T64 = DS_13.getData("62WHY1EOAR5NU7MQBYCU9AIX3", {}).value/10;

var A64 = DS_1.getData("62WHY1EOAR5NU41WIB9N3UBLY", {}).value/10;

if (Convert.floatToString(A64,"#0.00") == '0.00') {INPUTFIELD_64.setValue("0%");}

else if  (Convert.floatToString(A64,"#0.00") != '0.00') {var P64 = (A64/T64)*100;INPUTFIELD_64.setValue(Convert.floatToString(P64,"#0.00")+"%");}

//INPUTFIELD_64.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_69.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCUPC6YV", {}));

INPUTFIELD_60.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQSGQBU8", {}));

var T88 = DS_13.getData("62WHY1EOAR5NU7MQBYCUPC6YV", {}).value/10;

var A88 = DS_1.getData("62WHY1EOAR5PKEC80OQSGQBU8", {}).value/10;

if (Convert.floatToString(A88,"#0.00") == '0.00') {INPUTFIELD_88.setValue("0%");}

else if  (Convert.floatToString(A88,"#0.00") != '0.00') {var P88 = (A88/T88)*100;INPUTFIELD_88.setValue(Convert.floatToString(P88,"#0.00")+"%");}

//INPUTFIELD_88.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_78.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCU465VR", {}));

//EGP secondary sales value

INPUTFIELD_28.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZDQ6NM", {}));

INPUTFIELD_25.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01Z8PC1E", {}));

INPUTFIELD_43.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD5GEGJR", {}));

INPUTFIELD_52.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZIPA2A", {}));

var T73 = DS_13.getData("62WHY1EOAR5NU7MQBYD5GEGJR", {}).value/10;

var A73 = DS_1.getData("62WHY1EOAR5NU3ZXD01ZIPA2A", {}).value/10;

if (Convert.floatToString(A73,"#0.00") == '0.00') {INPUTFIELD_73.setValue("0%");}

else if  (Convert.floatToString(A73,"#0.00") != '0.00') {var P73 = (A73/T73)*100;INPUTFIELD_73.setValue(Convert.floatToString(P73,"#0.00")+"%");}

//INPUTFIELD_73.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_70.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD60VWP3", {}));

INPUTFIELD_61.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQSLR6GG", {}));

var T89 = DS_13.getData("62WHY1EOAR5NU7MQBYD60VWP3", {}).value/10;

var A89 = DS_1.getData("62WHY1EOAR5PKEC80OQSLR6GG", {}).value/10;

if (Convert.floatToString(A89,"#0.00") == '0.00') {INPUTFIELD_89.setValue("0%");}

else if  (Convert.floatToString(A89,"#0.00") != '0.00') {var P89 = (A89/T89)*100;INPUTFIELD_89.setValue(Convert.floatToString(P89,"#0.00")+"%");}

//INPUTFIELD_89.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_79.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD5BA3IF", {}));

//EGP secondary sales %

INPUTFIELD_26.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXZQZQT8HFR", {}));

INPUTFIELD_24.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXZQZQNFJGN", {}));

INPUTFIELD_44.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD4VRQRR", {}));

INPUTFIELD_53.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXZQZQYB39J", {}));

var T82 = DS_13.getData("62WHY1EOAR5NU7MQBYD4VRQRR", {}).value/10;

var A82 = DS_1.getData("62WHY1EOAR5NU3ZXZQZQYB39J", {}).value/10;

if (Convert.floatToString(A82,"#0.00") == '0.00') {INPUTFIELD_82.setValue("0%");}

else if  (Convert.floatToString(A82,"#0.00") != '0.00') {var P82 = (A82/T82)*100;INPUTFIELD_82.setValue(Convert.floatToString(P82,"#0.00")+"%");}

//INPUTFIELD_82.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_71.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD5VRJNR", {}));

INPUTFIELD_62.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQSQVJHS", {}));

var T90 = DS_13.getData("62WHY1EOAR5NU7MQBYD5VRJNR", {}).value/10;

var A90 = DS_1.getData("62WHY1EOAR5PKEC80OQSQVJHS", {}).value/10;

if (Convert.floatToString(A90,"#0.00") == '0.00') {INPUTFIELD_90.setValue("0%");}

else if  (Convert.floatToString(A90,"#0.00") != '0.00') {var P90 = (A90/T90)*100;INPUTFIELD_90.setValue(Convert.floatToString(P90,"#0.00")+"%");}

//INPUTFIELD_90.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_80.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD4QP4XZ", {}));

//Total Lubes Sales (Ltr.) Primary

//INPUTFIELD_30.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_23.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_45.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_54.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_83.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_72.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_63.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_91.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_81.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//Total Lubes Revenue (Ltr.) Secondary - Retail

INPUTFIELD_4.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZXRTWY", {}));

INPUTFIELD_101.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZSUHPU", {}));

INPUTFIELD_94.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD40ZTC7", {}));

INPUTFIELD_108.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD0202QXBM", {}));

var T123 = DS_13.getData("62WHY1EOAR5NU7MQBYD40ZTC7", {}).value/10;

var A123 = DS_1.getData("62WHY1EOAR5NU3ZXD0202QXBM", {}).value/10;

if (Convert.floatToString(A123,"#0.00") == '0.00') {INPUTFIELD_123.setValue("0%");}

else if  (Convert.floatToString(A123,"#0.00") != '0.00') {var P123 = (A123/T123)*100;INPUTFIELD_123.setValue(Convert.floatToString(P123,"#0.00")+"%");}

//INPUTFIELD_123.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_122.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD4LJ0P3", {}));

INPUTFIELD_111.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3XW15G8TL9SY", {}));

var T140 = DS_13.getData("62WHY1EOAR5NU7MQBYD4LJ0P3", {}).value/10;

var A140 = DS_1.getData("62WHY1EOAR5NU3XW15G8TL9SY", {}).value/10;

if (Convert.floatToString(A140,"#0.00") == '0.00') {INPUTFIELD_140.setValue("0%");}

else if  (Convert.floatToString(A140,"#0.00") != '0.00') {var P140 = (A140/T140)*100;INPUTFIELD_140.setValue(Convert.floatToString(P140,"#0.00")+"%");}

//INPUTFIELD_140.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_134.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYD3VTP3B", {}));

//Total Lubes Revenue (Lacs) Secondary - Retail

INPUTFIELD_105.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD020L4VG2", {}));

INPUTFIELD_99.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD020FRQCY", {}));

INPUTFIELD_93.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKI4KIV6TFWXK6", {}));

INPUTFIELD_119.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD020Q7H9U", {}));

var T121 = DS_13.getData("62WHY1EOAR5PKI4KIV6TFWXK6", {}).value/10;

var A121 = DS_1.getData("62WHY1EOAR5NU3ZXD020Q7H9U", {}).value/10;

if (Convert.floatToString(A121,"#0.00") == '0.00') {INPUTFIELD_121.setValue("0%");}

else if  (Convert.floatToString(A121,"#0.00") != '0.00') {var P121 = (A121/T121)*100;INPUTFIELD_121.setValue(Convert.floatToString(P121,"#0.00")+"%");}

//INPUTFIELD_121.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_120.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKI4KIV6T00J52", {}));

INPUTFIELD_109.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQSVY5BK", {}));

var T139 = DS_13.getData("62WHY1EOAR5PKI4KIV6T00J52", {}).value/10;

var A139 = DS_1.getData("62WHY1EOAR5PKEC80OQSVY5BK", {}).value/10;

if (Convert.floatToString(A139,"#0.00") == '0.00') {INPUTFIELD_139.setValue("0%");}

else if  (Convert.floatToString(A139,"#0.00") != '0.00') {var P139 = (A139/T139)*100;INPUTFIELD_139.setValue(Convert.floatToString(P139,"#0.00")+"%");}

//INPUTFIELD_139.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_133.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5PKI4KIV6TKXS6E", {}));

//EGP Secondary Sales Value (Lubes)

INPUTFIELD_104.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZXRTWY", {}));

INPUTFIELD_97.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD01ZSUHPU", {}));

INPUTFIELD_92.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCVQ9CUF", {}));

INPUTFIELD_117.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD021F9Z5E", {}));

var T127 = DS_13.getData("62WHY1EOAR5NU7MQBYCVQ9CUF", {}).value/10;

var A127 = DS_1.getData("62WHY1EOAR5NU3ZXD021F9Z5E", {}).value/10;

if (Convert.floatToString(A127,"#0.00") == '0.00') {INPUTFIELD_127.setValue("0%");}

else if  (Convert.floatToString(A127,"#0.00") != '0.00') {var P127 = (A127/T127)*100;INPUTFIELD_127.setValue(Convert.floatToString(P127,"#0.00")+"%");}

//INPUTFIELD_127.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_118.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCV4SSHZ", {}));

INPUTFIELD_107.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQT17RZK", {}));

var T137 = DS_13.getData("62WHY1EOAR5NU7MQBYCV4SSHZ", {}).value/10;

var A137 = DS_1.getData("62WHY1EOAR5PKEC80OQT17RZK", {}).value/10;

if (Convert.floatToString(A137,"#0.00") == '0.00') {INPUTFIELD_137.setValue("0%");}

else if  (Convert.floatToString(A137,"#0.00") != '0.00') {var P137 = (A137/T137)*100;INPUTFIELD_137.setValue(Convert.floatToString(P137,"#0.00")+"%");}

//INPUTFIELD_137.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_132.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCVVDPVR", {}));

//EGP Secondary Sales %(Lubes)

INPUTFIELD_102.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZYBZMRUANGN", {}));

INPUTFIELD_95.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXZQZQNFJGN", {}));

INPUTFIELD_114.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCWBH553", {}));

INPUTFIELD_125.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZYBZMRZD9AF", {}));

var T130 = DS_13.getData("62WHY1EOAR5NU7MQBYCWBH553", {}).value/10;

var A130 = DS_1.getData("62WHY1EOAR5NU3ZYBZMRZD9AF", {}).value/10;

if (Convert.floatToString(A130,"#0.00") == '0.00') {INPUTFIELD_130.setValue("0%");}

else if  (Convert.floatToString(A130,"#0.00") != '0.00') {var P130 = (A130/T130)*100;INPUTFIELD_130.setValue(Convert.floatToString(P130,"#0.00")+"%");}

//INPUTFIELD_130.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_116.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCVA5XL3", {}));

INPUTFIELD_106.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEC80OQT6ADTC", {}));

var T138 = DS_13.getData("62WHY1EOAR5NU7MQBYCVA5XL3", {}).value/10;

var A138 = DS_1.getData("62WHY1EOAR5PKEC80OQT6ADTC", {}).value/10;

if (Convert.floatToString(A138,"#0.00") == '0.00') {INPUTFIELD_138.setValue("0%");}

else if  (Convert.floatToString(A138,"#0.00") != '0.00') {var P138 = (A138/T138)*100;INPUTFIELD_138.setValue(Convert.floatToString(P138,"#0.00")+"%");}

//INPUTFIELD_138.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_131.setValue(DS_13.getDataAsStringExt("62WHY1EOAR5NU7MQBYCWGLI6F", {}));

//secondary retail market share %

INPUTFIELD_103.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKHLCSQ4BHL46B", {}));

INPUTFIELD_98.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKHLCHROLJAFOH", {}));

INPUTFIELD_112.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A99PTUPZ", {}));

INPUTFIELD_129.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKHLCSQ4BNJBS3", {}));

var T128 = DS_6.getData("62WHY1EOAR5PKI4I2A99PTUPZ", {}).value/10;

var A128 = DS_4.getData("62WHY1EOAR5PKHLCSQ4BNJBS3", {}).value/10;

if (Convert.floatToString(A128,"#0.00") == '0.00') {INPUTFIELD_128.setValue("0%");}

else if  (Convert.floatToString(A128,"#0.00") != '0.00') {var P128 = (A128/T128)*100;INPUTFIELD_128.setValue(Convert.floatToString(P128,"#0.00")+"%");}

//INPUTFIELD_128.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_115.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A99AKA13", {}));

INPUTFIELD_141.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKHLCHROL9Z2LD", {}));

var T136 = DS_6.getData("62WHY1EOAR5PKI4I2A99AKA13", {}).value/10;

var A136 = DS_4.getData("62WHY1EOAR5PKHLCHROL9Z2LD", {}).value/10;

if (Convert.floatToString(A136,"#0.00") == '0.00') {INPUTFIELD_136.setValue("0%");}

else if  (Convert.floatToString(A136,"#0.00") != '0.00') {var P136 = (A136/T136)*100;INPUTFIELD_136.setValue(Convert.floatToString(P136,"#0.00")+"%");}

//INPUTFIELD_136.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_145.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A99UWGJR", {}));

//Secondary Lube Market Share %

INPUTFIELD_100.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67XBHP9V", {}));

INPUTFIELD_96.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67X6BL0Z", {}));

INPUTFIELD_110.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A98L903R", {}));

INPUTFIELD_126.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67XGM2B7", {}));

var T124 = DS_6.getData("62WHY1EOAR5PKI4I2A98L903R", {}).value/10;

var A124 = DS_4.getData("62WHY1EOAR5NU779Y67XGM2B7", {}).value/10;

if (Convert.floatToString(A124,"#0.00") == '0.00') {INPUTFIELD_124.setValue("0%");}

else if  (Convert.floatToString(A124,"#0.00") != '0.00') {var P124 = (A124/T124)*100;INPUTFIELD_124.setValue(Convert.floatToString(P124,"#0.00")+"%");}

//INPUTFIELD_124.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_113.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A97FG98N", {}));

INPUTFIELD_142.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67X18Z77", {}));

var T135 = DS_6.getData("62WHY1EOAR5PKI4I2A97FG98N", {}).value/10;

var A135 = DS_4.getData("62WHY1EOAR5NU779Y67X18Z77", {}).value/10;

if (Convert.floatToString(A135,"#0.00") == '0.00') {INPUTFIELD_135.setValue("0%");}

else if  (Convert.floatToString(A135,"#0.00") != '0.00') {var P135 = (A135/T135)*100;INPUTFIELD_135.setValue(Convert.floatToString(P135,"#0.00")+"%");}

//INPUTFIELD_135.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_144.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4I2A98QF4CN", {}));

//PVPA Secondary Retail

INPUTFIELD_565.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67WKWRW3", {}));

INPUTFIELD_564.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67WFAUR7", {}));

INPUTFIELD_563.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5NU7QF65HSBITQH", {}));

INPUTFIELD_562.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67WQ2W4Z", {}));

var T561 = DS_6.getData("62WHY1EOAR5NU7QF65HSBITQH", {}).value/10;

var A561 = DS_4.getData("62WHY1EOAR5NU779Y67WQ2W4Z", {}).value/10;

if (Convert.floatToString(A561,"#0.00") == '0.00') {INPUTFIELD_561.setValue("0%");}

else if  (Convert.floatToString(A561,"#0.00") != '0.00') {var P561 = (A561/T561)*100;INPUTFIELD_561.setValue(Convert.floatToString(P561,"#0.00")+"%");}

//INPUTFIELD_561.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_560.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5PKI4MK028ROD6D", {}));

INPUTFIELD_550.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5NU779Y67W46IWJ", {}));

var T567 = DS_6.getData("62WHY1EOAR5PKI4MK028ROD6D", {}).value/10;

var A567 = DS_4.getData("62WHY1EOAR5NU779Y67W46IWJ", {}).value/10;

if (Convert.floatToString(A567,"#0.00") == '0.00') {INPUTFIELD_567.setValue("0%");}

else if  (Convert.floatToString(A567,"#0.00") != '0.00') {var P567 = (A567/T567)*100;INPUTFIELD_567.setValue(Convert.floatToString(P567,"#0.00")+"%");}

//INPUTFIELD_567.setValue(DS_4.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_566.setValue(DS_6.getDataAsStringExt("62WHY1EOAR5NU7QF65HSHFA4P", {}));

//Closing ( Month-end) Stock – Spares

//Spares Closing Stock Value (Rs.)

//INPUTFIELD_1.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_3.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_5.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DXFIQB", {}));

//INPUTFIELD_6.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_8.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_10.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DI9GGJ", {}));

//INPUTFIELD_12.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_14.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_15.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DD8LUB", {}));

//Spare Transit Closing Stock Value (Rs.)

//INPUTFIELD_16.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_19.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_32.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DXFIQB", {}));

//INPUTFIELD_36.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_37.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_38.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DI9GGJ", {}));

//INPUTFIELD_39.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_40.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_41.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DD8LUB", {}));

//Spares Closing Stock Value with Transit (Rs)  (A14+A15)

//INPUTFIELD_143.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_146.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_147.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DXFIQB", {}));

//INPUTFIELD_148.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_149.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_150.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DI9GGJ", {}));

//INPUTFIELD_151.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_152.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_153.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572DD8LUB", {}));

//Spares Avg. Inventory for the Month [(opening stock + closing stock)]/2

//INPUTFIELD_154.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_155.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_156.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7ORYCZQC4EOA", {}));

//INPUTFIELD_157.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_158.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_159.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7ORYCZPX1UTM", {}));

//INPUTFIELD_160.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_161.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_162.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7ORYCZPRCF9M", {}));

//Stock in of Days (Actuals Based on A24)

//INPUTFIELD_163.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_164.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_165.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572CINP8Z", {}));

//INPUTFIELD_166.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_167.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_168.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572C3L5EB", {}));

//INPUTFIELD_169.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_170.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_171.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572BXMXSJ", {}));

//Stock Turns  (Actuals Based on A24)

//INPUTFIELD_172.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_173.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_174.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP9RT8WLSFJ", {}));

//INPUTFIELD_175.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_176.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_177.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP9RT8HDYY7", {}));

//INPUTFIELD_178.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_179.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_180.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP9RT8BQALR", {}));

//Partline In Stock

//INPUTFIELD_181.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_182.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_183.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5PKIQJIN7J7X4VG", {}));

//INPUTFIELD_184.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_185.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_186.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5PKIQJIN7ISR2LO", {}));

//INPUTFIELD_187.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_188.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_189.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5PKIQJIN7IN1N1O", {}));

//Partline Sold

INPUTFIELD_190.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEE9XMFTFFBWJ", {}));

INPUTFIELD_191.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEE9XMFT9MDXF", {}));

INPUTFIELD_192.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572D89IFN", {}));

INPUTFIELD_193.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEE9XMFTKG6IR", {}));

var T194 = DS_12.getData("62WHY1EOAR5NU7OP572D89IFN", {}).value/10;

var A194 = DS_1.getData("62WHY1EOAR5PKEE9XMFTKG6IR", {}).value/10;

if (Convert.floatToString(A194,"#0.00") == '0.00') {INPUTFIELD_194.setValue("0%");}

else if  (Convert.floatToString(A194,"#0.00") != '0.00') {var P194 = (A194/T194)*100;INPUTFIELD_194.setValue(Convert.floatToString(P194,"#0.00")+"%");}

//INPUTFIELD_194.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_195.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572CSWFBN", {}));

INPUTFIELD_196.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU4011DXBEWLL3", {}));

var T197 = DS_12.getData("62WHY1EOAR5NU7OP572CSWFBN", {}).value/10;

var A197 = DS_1.getData("62WHY1EOAR5NU4011DXBEWLL3", {}).value/10;

if (Convert.floatToString(A197,"#0.00") == '0.00') {INPUTFIELD_197.setValue("0%");}

else if  (Convert.floatToString(A197,"#0.00") != '0.00') {var P197 = (A197/T197)*100;INPUTFIELD_197.setValue(Convert.floatToString(P197,"#0.00")+"%");}

//INPUTFIELD_197.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_198.setValue(DS_12.getDataAsStringExt("62WHY1EOAR5NU7OP572CNVKPF", {}));

//Closing Month-end Stock – Lubes

//Lubes Physical Stock Value (Lacs)

//INPUTFIELD_208.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_209.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_210.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OSNLEINFDOP", {}));

//INPUTFIELD_211.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_212.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_213.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OSNLEICJTVT", {}));

//INPUTFIELD_214.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_215.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_216.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5PKI2SBX889N5UB", {}));

//Lubes Physical Stock Value (Ltr)

//INPUTFIELD_217.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_218.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_219.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ557B2OG7", {}));

//INPUTFIELD_220.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_221.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_222.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ556Y5DTZ", {}));

//INPUTFIELD_223.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_224.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_225.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OSNLEIXO3RD", {}));

//Lubes Avg. Inventory for the Month [(opening stock + closing stock)]/2

//INPUTFIELD_226.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_227.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_228.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OTDKLTD0D2N", {}));

//INPUTFIELD_229.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_230.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_231.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OTA6NMBNPDB", {}));

//INPUTFIELD_232.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_233.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_234.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OTA6NM0S5KF", {}));

//Stock in of Days (Actuals Based on A32)

//INPUTFIELD_235.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_236.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_237.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ556RILAF", {}));

//INPUTFIELD_238.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_239.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_240.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ5567YI4N", {}));

//INPUTFIELD_241.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_242.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_243.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7MH0Z5KPBGMA", {}));

//Stock Turns  (Actuals Based on A32)

//INPUTFIELD_244.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_245.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_246.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ555UQO93", {}));

//INPUTFIELD_247.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_248.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_249.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7OQQ555GEGJR", {}));

//INPUTFIELD_250.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_251.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_252.setValue(DS_11.getDataAsStringExt("62WHY1EOAR5NU7MH0Z5KK8USI", {}));

//Channel Working (Need to adapt as per upload sheet)

//No.of Retaliers Billed 0-50 Partline

INPUTFIELD_254.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE203FIK95", {}));

INPUTFIELD_256.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE203AHPMX", {}));

INPUTFIELD_253.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX14OWE2Y", {}));

INPUTFIELD_255.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE203KHNNT", {}));

var T257 = DS_10.getData("62WHY1EOAR5NU7OMHX14OWE2Y", {}).value/10;

var A257 = DS_3.getData("62WHY1EOAR5NU78QE203KHNNT", {}).value/10;

if (Convert.floatToString(A257,"#0.00") == '0.00') {INPUTFIELD_257.setValue("0%");}

else if  (Convert.floatToString(A257,"#0.00") != '0.00') {var P257 = (A257/T257)*100;INPUTFIELD_257.setValue(Convert.floatToString(P257,"#0.00")+"%");}

//INPUTFIELD_257.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_258.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX14300UI", {}));

INPUTFIELD_261.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE2035GV0P", {}));

var T259 = DS_10.getData("62WHY1EOAR5NU7OMHX14300UI", {}).value/10;

var A259 = DS_3.getData("62WHY1EOAR5NU78QE2035GV0P", {}).value/10;

if (Convert.floatToString(A259,"#0.00") == '0.00') {INPUTFIELD_259.setValue("0%");}

else if  (Convert.floatToString(A259,"#0.00") != '0.00') {var P259 = (A259/T259)*100;INPUTFIELD_259.setValue(Convert.floatToString(P259,"#0.00")+"%");}

//INPUTFIELD_259.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_260.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX13UYB7U", {}));

//No.of Retaliers Billed 51-100 Partline

INPUTFIELD_262.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE202QJKSP", {}));

INPUTFIELD_263.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE202LGYYX", {}));

INPUTFIELD_264.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX15PH9HM", {}));

INPUTFIELD_265.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE202VIO7D", {}));

var T266 = DS_10.getData("62WHY1EOAR5NU7OMHX15PH9HM", {}).value/10;

var A266 = DS_3.getData("62WHY1EOAR5NU78QE202VIO7D", {}).value/10;

if (Convert.floatToString(A266,"#0.00") == '0.00') {INPUTFIELD_266.setValue("0%");}

else if  (Convert.floatToString(A266,"#0.00") != '0.00') {var P266 = (A266/T266)*100;INPUTFIELD_266.setValue(Convert.floatToString(P266,"#0.00")+"%");}

//INPUTFIELD_266.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_267.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX153MNGQ", {}));

INPUTFIELD_268.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE202GCLXL", {}));

var T269 = DS_10.getData("62WHY1EOAR5NU7OMHX153MNGQ", {}).value/10;

var A269 = DS_3.getData("62WHY1EOAR5NU78QE202GCLXL", {}).value/10;

if (Convert.floatToString(A269,"#0.00") == '0.00') {INPUTFIELD_269.setValue("0%");}

else if  (Convert.floatToString(A269,"#0.00") != '0.00') {var P269 = (A269/T269)*100;INPUTFIELD_269.setValue(Convert.floatToString(P269,"#0.00")+"%");}

//INPUTFIELD_269.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_270.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMHX14WESEI", {}));

//No.of Retaliers Billed 101-200 Partline

INPUTFIELD_271.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE2021BTAH", {}));

INPUTFIELD_272.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE201WAYO9", {}));

INPUTFIELD_273.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2V2UDNBR980", {}));

INPUTFIELD_274.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE2026CNWP", {}));

var T275 = DS_10.getData("62WHY1EOAR5PKI2V2UDNBR980", {}).value/10;

var A275 = DS_3.getData("62WHY1EOAR5NU78QE2026CNWP", {}).value/10;

if (Convert.floatToString(A275,"#0.00") == '0.00') {INPUTFIELD_275.setValue("0%");}

else if  (Convert.floatToString(A275,"#0.00") != '0.00') {var P275 = (A275/T275)*100;INPUTFIELD_275.setValue(Convert.floatToString(P275,"#0.00")+"%");}

//INPUTFIELD_275.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_276.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2V2UDMWQGKW", {}));

INPUTFIELD_277.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE201R8CUH", {}));

var T278 = DS_10.getData("62WHY1EOAR5PKI2V2UDMWQGKW", {}).value/10;

var A278 = DS_3.getData("62WHY1EOAR5NU78QE201R8CUH", {}).value/10;

if (Convert.floatToString(A278,"#0.00") == '0.00') {INPUTFIELD_278.setValue("0%");}

else if  (Convert.floatToString(A278,"#0.00") != '0.00') {var P278 = (A278/T278)*100;INPUTFIELD_278.setValue(Convert.floatToString(P278,"#0.00")+"%");}

//INPUTFIELD_278.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_279.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2V2UDMQZ9TC", {}));

// No.of Retaliers Billed 201-500 Partline

INPUTFIELD_280.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE201BV9QH", {}));

INPUTFIELD_281.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE2016W6BT", {}));

INPUTFIELD_282.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYNCTGQIY", {}));

INPUTFIELD_283.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE201H6NM1", {}));

var T284 = DS_10.getData("62WHY1EOAR5NU7OMTYNCTGQIY", {}).value/10;

var A284 = DS_3.getData("62WHY1EOAR5NU78QE201H6NM1", {}).value/10;

if (Convert.floatToString(A284,"#0.00") == '0.00') {INPUTFIELD_284.setValue("0%");}

else if  (Convert.floatToString(A284,"#0.00") != '0.00') {var P284 = (A284/T284)*100;INPUTFIELD_284.setValue(Convert.floatToString(P284,"#0.00")+"%");}

//INPUTFIELD_284.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_285.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYNCEE6OA", {}));

INPUTFIELD_286.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE2011X2X5", {}));

var T287 = DS_10.getData("62WHY1EOAR5NU7OMTYNCEE6OA", {}).value/10;

var A287 = DS_3.getData("62WHY1EOAR5NU78QE2011X2X5", {}).value/10;

if (Convert.floatToString(A287,"#0.00") == '0.00') {INPUTFIELD_287.setValue("0%");}

else if  (Convert.floatToString(A287,"#0.00") != '0.00') {var P287 = (A287/T287)*100;INPUTFIELD_287.setValue(Convert.floatToString(P287,"#0.00")+"%");}

//INPUTFIELD_287.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_288.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYNC8QIBU", {}));

//No.of Retaliers Billed 501-750 Partline

INPUTFIELD_289.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE200MLR0P", {}));

INPUTFIELD_290.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE200RTMH5", {}));

INPUTFIELD_291.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYNDIOI16", {}));

INPUTFIELD_292.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE200HHDZD", {}));

var T293 = DS_10.getData("62WHY1EOAR5NU7OMTYNDIOI16", {}).value/10;

var A293 = DS_3.getData("62WHY1EOAR5NU78QE200HHDZD", {}).value/10;

if (Convert.floatToString(A293,"#0.00") == '0.00') {INPUTFIELD_293.setValue("0%");}

else if  (Convert.floatToString(A293,"#0.00") != '0.00') {var P293 = (A293/T293)*100;INPUTFIELD_293.setValue(Convert.floatToString(P293,"#0.00")+"%");}

//INPUTFIELD_293.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_294.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYND3IFRE", {}));

INPUTFIELD_295.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78QE200WUH3D", {}));

var T296 = DS_10.getData("62WHY1EOAR5NU7OMTYND3IFRE", {}).value/10;

var A296 = DS_3.getData("62WHY1EOAR5NU78QE200WUH3D", {}).value/10;

if (Convert.floatToString(A296,"#0.00") == '0.00') {INPUTFIELD_296.setValue("0%");}

else if  (Convert.floatToString(A296,"#0.00") != '0.00') {var P296 = (A296/T296)*100;INPUTFIELD_296.setValue(Convert.floatToString(P296,"#0.00")+"%");}

//INPUTFIELD_296.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_297.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMTYNCYJCCQ", {}));

//No.of Retaliers Billed 751-1000 Partline

INPUTFIELD_298.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78R0Y39ZNNEA", {}));

INPUTFIELD_299.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78R0Y39UJACY", {}));

INPUTFIELD_300.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMX3SBMT00A", {}));

INPUTFIELD_301.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78R0Y3A4S0FM", {}));

var T302 = DS_10.getData("62WHY1EOAR5NU7OMX3SBMT00A", {}).value/10;

var A302 = DS_3.getData("62WHY1EOAR5NU78R0Y3A4S0FM", {}).value/10;

if (Convert.floatToString(A302,"#0.00") == '0.00') {INPUTFIELD_302.setValue("0%");}

else if  (Convert.floatToString(A302,"#0.00") != '0.00') {var P302 = (A302/T302)*100;INPUTFIELD_302.setValue(Convert.floatToString(P302,"#0.00")+"%");}

//INPUTFIELD_302.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_303.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMX3SB1056Y", {}));

INPUTFIELD_304.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78R0Y39OHKC2", {}));

var T305 = DS_10.getData("62WHY1EOAR5NU7OMX3SB1056Y", {}).value/10;

var A305 = DS_3.getData("62WHY1EOAR5NU78R0Y39OHKC2", {}).value/10;

if (Convert.floatToString(A305,"#0.00") == '0.00') {INPUTFIELD_305.setValue("0%");}

else if  (Convert.floatToString(A305,"#0.00") != '0.00') {var P305 = (A305/T305)*100;INPUTFIELD_305.setValue(Convert.floatToString(P305,"#0.00")+"%");}

//INPUTFIELD_305.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_306.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5NU7OMX3SASM53E", {}));

//No.of Retailers Billed > 1000 Partline

INPUTFIELD_307.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78RP4G7CDEDL", {}));

INPUTFIELD_308.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78RP4G77ASJT", {}));

INPUTFIELD_309.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2VHA3K4HASH", {}));

INPUTFIELD_310.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78R0Y3A4S0FM", {}));

var T311 = DS_10.getData("62WHY1EOAR5PKI2VHA3K4HASH", {}).value/10;

var A311 = DS_3.getData("62WHY1EOAR5NU78R0Y3A4S0FM", {}).value/10;

if (Convert.floatToString(A311,"#0.00") == '0.00') {INPUTFIELD_311.setValue("0%");}

else if  (Convert.floatToString(A311,"#0.00") != '0.00') {var P311 = (A311/T311)*100;INPUTFIELD_311.setValue(Convert.floatToString(P311,"#0.00")+"%");}

//INPUTFIELD_311.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_312.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2VHA3JORX7L", {}));

INPUTFIELD_313.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5NU78RP4G70WS21", {}));

var T314 = DS_10.getData("62WHY1EOAR5PKI2VHA3JORX7L", {}).value/10;

var A314 = DS_3.getData("62WHY1EOAR5NU78RP4G70WS21", {}).value/10;

if (Convert.floatToString(A314,"#0.00") == '0.00') {INPUTFIELD_314.setValue("0%");}

else if  (Convert.floatToString(A314,"#0.00") != '0.00') {var P314 = (A314/T314)*100;INPUTFIELD_314.setValue(Convert.floatToString(P314,"#0.00")+"%");}

//INPUTFIELD_314.setValue(DS_3.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_315.setValue(DS_10.getDataAsStringExt("62WHY1EOAR5PKI2VHA3JJ2HNL", {}));

//Spares Promotion

//No. of Marketing Activities conducted

//INPUTFIELD_325.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_326.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_327.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TF2IU6F", {}));

//INPUTFIELD_328.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_329.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_330.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TEMH64N", {}));

//INPUTFIELD_331.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_332.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_333.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TF7LG07", {}));

//No. of Marketing Man-days conducted

//INPUTFIELD_334.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_335.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_336.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TFRSCW7", {}));

//INPUTFIELD_337.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_338.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_339.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TFCO1TZ", {}));

//INPUTFIELD_340.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_341.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_342.setValue(DS_9.getDataAsStringExt("62WHY1EOAR5PKI2VH8TFWRGAV", {}));

//Retailer Satisfaction

//Avg. Retailer Satisfaction Score

//INPUTFIELD_352.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_353.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_354.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZLZA7493", {}));

//INPUTFIELD_355.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_356.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_357.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZLYUE893", {}));

//INPUTFIELD_358.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_359.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_360.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZLZFBHAF", {}));

/*

//Open Complaints

INPUTFIELD_361.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_362.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_363.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_364.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_365.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_366.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_367.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_368.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_369.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

*/

//% Retailers Contacted

//INPUTFIELD_370.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_371.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_372.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM00HIDJ", {}));

//INPUTFIELD_373.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_374.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_375.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZLZKFUBR", {}));

//INPUTFIELD_376.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_377.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_378.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM05ICZR", {}));

//% Feedback Collected

//INPUTFIELD_379.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_380.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_381.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM0PNIO7", {}));

//INPUTFIELD_382.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_383.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_384.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM0AJ7LZ", {}));

//INPUTFIELD_385.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_386.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_387.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM0UODAF", {}));

//Spare Parts Ordering

//Service Index

//INPUTFIELD_388.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_389.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_390.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM1NCSP3", {}));

//INPUTFIELD_391.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_392.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_393.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM17EN2F", {}));

//INPUTFIELD_394.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_395.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_396.setValue(DS_8.getDataAsStringExt("62WHY1EOAR5PKI2X9ZM1SDNBB", {}));

//No. of VOR Orders (# of Part-lines) - Dealer - Order Type ZVOR (target and %ach will be blank for VOR)

INPUTFIELD_402.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSRF25JH", {}));

INPUTFIELD_403.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSR97GCT", {}));

//INPUTFIELD_401.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_399.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSRK6IKT", {}));

//INPUTFIELD_400.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_398.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_397.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1I1T9KQUS3", {}));

//INPUTFIELD_405.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_404.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSRPCMTP", {}));

//No. of VOR Orders (# of Part-lines) - Retail- Order Type ZEME(target and %ach will be blank for VOR)

INPUTFIELD_406.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSRZSDQL", {}));

INPUTFIELD_407.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSRUF8NH", {}));

//INPUTFIELD_408.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_409.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSS4T8CT", {}));

//INPUTFIELD_410.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_411.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_412.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1I1T9QSKSZ", {}));

//INPUTFIELD_413.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_414.setValue(DS_2.getDataAsStringExt("62WHY1EOAR5PKEG1ZQSS9U2Z1", {}));

/*

//Channel Working

//No. of New Retailer Added (in last month for actual)

INPUTFIELD_424.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_425.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_426.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_427.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_428.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_429.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_430.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_431.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_432.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

*/

//No. of Billed EGP Retailers

INPUTFIELD_433.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD021UVUB6", {}));

INPUTFIELD_434.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD021PPQ2A", {}));

//INPUTFIELD_435.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_436.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD021ZUXPU", {}));

//INPUTFIELD_437.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_438.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_439.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKECB96ESB6UWZ", {}));

//INPUTFIELD_440.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_441.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU3ZXD0224U14I", {}));

//No. of Billed Multi-brand Retailers

INPUTFIELD_442.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU7S7XSAUYXHYN", {}));

INPUTFIELD_443.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU7S7XSAUT6B73", {}));

//INPUTFIELD_444.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_445.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU7S7XSAV403SF", {}));

//INPUTFIELD_446.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_447.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_448.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG37PYPNO3NX", {}));

//INPUTFIELD_449.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_450.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU7S7XSAV8Z773", {}));

//platinum

INPUTFIELD_451.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9NM4RBA", {}));

INPUTFIELD_452.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9NH3WP2", {}));

//INPUTFIELD_453.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_454.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9NR7D52", {}));

//INPUTFIELD_455.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_456.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_457.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG37PYPTO2H9", {}));

//INPUTFIELD_458.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_459.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WIB9NW87RA", {}));

//gold

INPUTFIELD_460.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG52QJ22HZ6B", {}));

INPUTFIELD_461.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG52QJ1WQSER", {}));

//INPUTFIELD_462.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_463.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG52QJ27KL03", {}));

//INPUTFIELD_464.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_465.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_466.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41V4PYK921IQ", {}));

//INPUTFIELD_467.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_468.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKEG52QJ2CJOER", {}));

//silver

INPUTFIELD_469.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WQHHMIZJGQ", {}));

INPUTFIELD_470.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WQHHM5PYDM", {}));

//INPUTFIELD_471.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_472.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WQHHMO3WI2", {}));

//INPUTFIELD_473.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_474.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_475.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41V4PYKEYHWY", {}));

//INPUTFIELD_476.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_477.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WQHHMT4R4A", {}));

//Bronze

INPUTFIELD_478.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WVQWFDPMIY", {}));

INPUTFIELD_479.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WVQWF7YFRE", {}));

//INPUTFIELD_480.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_481.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WVQWFIS8CQ", {}));

//INPUTFIELD_482.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

//INPUTFIELD_483.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_484.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41V4PYKJZCJ6", {}));

//INPUTFIELD_485.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_486.setValue(DS_1.getDataAsStringExt("62WHY1EOAR5NU41WVQWFNRBRE", {}));

//Connect

//No. of Mechanics Registered

INPUTFIELD_496.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00XDGKTS", {}));

INPUTFIELD_497.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00XIMP2O", {}));

INPUTFIELD_498.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONHVUULUIVS", {}));

INPUTFIELD_499.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00XNR240", {}));

var T500 = DS_7.getData("62WHY1EOAR5NU7ONHVUULUIVS", {}).value/10;

var A500 = DS_5.getData("62WHY1EOAR5PKI4GH00XNR240", {}).value/10;

if (Convert.floatToString(A500,"#0.00") == '0.00') {INPUTFIELD_500.setValue("0%");}

else if  (Convert.floatToString(A500,"#0.00") != '0.00') {var P500 = (A500/T500)*100;INPUTFIELD_500.setValue(Convert.floatToString(P500,"#0.00")+"%");}

//INPUTFIELD_500.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_501.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONHVUU6OGM0", {}));

INPUTFIELD_502.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00X8DZ00", {}));

var T503 = DS_7.getData("62WHY1EOAR5NU7ONHVUU6OGM0", {}).value/10;

var A503 = DS_5.getData("62WHY1EOAR5PKI4GH00X8DZ00", {}).value/10;

if (Convert.floatToString(A503,"#0.00") == '0.00') {INPUTFIELD_503.setValue("0%");}

else if  (Convert.floatToString(A503,"#0.00") != '0.00') {var P503 = (A503/T503)*100;INPUTFIELD_503.setValue(Convert.floatToString(P503,"#0.00")+"%");}

//INPUTFIELD_503.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_504.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONHVUU0Z120", {}));

//No. of Active Mechanics

INPUTFIELD_505.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00ZSDGTS", {}));

INPUTFIELD_506.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00ZN93SG", {}));

INPUTFIELD_507.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONL0TFBH4IG", {}));

INPUTFIELD_508.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00ZI6HYO", {}));

var T509 = DS_7.getData("62WHY1EOAR5NU7ONL0TFBH4IG", {}).value/10;

var A509 = DS_5.getData("62WHY1EOAR5PKI4GH00ZI6HYO", {}).value/10;

if (Convert.floatToString(A509,"#0.00") == '0.00') {INPUTFIELD_509.setValue("0%");}

else if  (Convert.floatToString(A509,"#0.00") != '0.00') {var P509 = (A509/T509)*100;INPUTFIELD_509.setValue(Convert.floatToString(P509,"#0.00")+"%");}

//INPUTFIELD_509.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_510.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONL0TEWEKNS", {}));

INPUTFIELD_511.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00XXW9RK", {}));

var T512 = DS_7.getData("62WHY1EOAR5NU7ONL0TEWEKNS", {}).value/10;

var A512 = DS_5.getData("62WHY1EOAR5PKI4GH00XXW9RK", {}).value/10;

if (Convert.floatToString(A512,"#0.00") == '0.00') {INPUTFIELD_512.setValue("0%");}

else if  (Convert.floatToString(A512,"#0.00") != '0.00') {var P512 = (A512/T512)*100;INPUTFIELD_512.setValue(Convert.floatToString(P512,"#0.00")+"%");}

//INPUTFIELD_512.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_513.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONL0TEQNDW8", {}));

//Dail-a-part

//NO. of Calls Recd

INPUTFIELD_523.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00Z2TEUO", {}));

INPUTFIELD_524.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00Y838MO", {}));

INPUTFIELD_525.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KD260QV", {}));

INPUTFIELD_526.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00YSH6CW", {}));

var T527 = DS_7.getData("62WHY1EOAR5NU7ONT9KD260QV", {}).value/10;

var A527 = DS_5.getData("62WHY1EOAR5PKI4GH00YSH6CW", {}).value/10;

if (Convert.floatToString(A527,"#0.00") == '0.00') {INPUTFIELD_527.setValue("0%");}

else if  (Convert.floatToString(A527,"#0.00") != '0.00') {var P527 = (A527/T527)*100;INPUTFIELD_527.setValue(Convert.floatToString(P527,"#0.00")+"%");}

//INPUTFIELD_527.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_528.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KCMWG1Z", {}));

INPUTFIELD_529.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00Z7XRW0", {}));

var T530 = DS_7.getData("62WHY1EOAR5NU7ONT9KCMWG1Z", {}).value/10;

var A530 = DS_5.getData("62WHY1EOAR5PKI4GH00Z7XRW0", {}).value/10;

if (Convert.floatToString(A530,"#0.00") == '0.00') {INPUTFIELD_530.setValue("0%");}

else if  (Convert.floatToString(A530,"#0.00") != '0.00') {var P530 = (A530/T530)*100;INPUTFIELD_530.setValue(Convert.floatToString(P530,"#0.00")+"%");}

//INPUTFIELD_530.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_531.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KCH8RPJ", {}));

//No. of Calls Closed within 30 mins

INPUTFIELD_532.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00YD7LO0", {}));

INPUTFIELD_533.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00Y838MO", {}));

INPUTFIELD_534.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KDRFJGN", {}));

INPUTFIELD_535.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00Y30MSW", {}));

var T536 = DS_7.getData("62WHY1EOAR5NU7ONT9KDRFJGN", {}).value/10;

var A536 = DS_5.getData("62WHY1EOAR5PKI4GH00Y30MSW", {}).value/10;

if (Convert.floatToString(A536,"#0.00") == '0.00') {INPUTFIELD_536.setValue("0%");}

else if  (Convert.floatToString(A536,"#0.00") != '0.00') {var P536 = (A536/T536)*100;INPUTFIELD_536.setValue(Convert.floatToString(P536,"#0.00")+"%");}

//INPUTFIELD_536.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_537.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KDCCZLZ", {}));

INPUTFIELD_538.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00YIA7HS", {}));

var T539 = DS_7.getData("62WHY1EOAR5NU7ONT9KDCCZLZ", {}).value/10;

var A539 = DS_5.getData("62WHY1EOAR5PKI4GH00YIA7HS", {}).value/10;

if (Convert.floatToString(A539,"#0.00") == '0.00') {INPUTFIELD_539.setValue("0%");}

else if  (Convert.floatToString(A539,"#0.00") != '0.00') {var P539 = (A539/T539)*100;INPUTFIELD_539.setValue(Convert.floatToString(P539,"#0.00")+"%");}

//INPUTFIELD_539.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_540.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONT9KD7ADS7", {}));

//% Adherance (A72/A71)

INPUTFIELD_541.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00W85E28", {}));

INPUTFIELD_542.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00W3110W", {}));

INPUTFIELD_543.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7OO5EC79P6PB", {}));

INPUTFIELD_544.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00VXWNZK", {}));

var T545 = DS_7.getData("62WHY1EOAR5NU7OO5EC79P6PB", {}).value/10;

var A545 = DS_5.getData("62WHY1EOAR5PKI4GH00VXWNZK", {}).value/10;

if (Convert.floatToString(A545,"#0.00") == '0.00') {INPUTFIELD_545.setValue("0%");}

else if  (Convert.floatToString(A545,"#0.00") != '0.00') {var P545 = (A545/T545)*100;INPUTFIELD_545.setValue(Convert.floatToString(P545,"#0.00")+"%");}

//INPUTFIELD_545.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_546.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7OO5EC6U3BJJ", {}));

INPUTFIELD_547.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00VSQJQO", {}));

var T548 = DS_7.getData("62WHY1EOAR5NU7OO5EC6U3BJJ", {}).value/10;

var A548 = DS_5.getData("62WHY1EOAR5PKI4GH00VSQJQO", {}).value/10;

if (Convert.floatToString(A548,"#0.00") == '0.00') {INPUTFIELD_548.setValue("0%");}

else if  (Convert.floatToString(A548,"#0.00") != '0.00') {var P548 = (A548/T548)*100;INPUTFIELD_548.setValue(Convert.floatToString(P548,"#0.00")+"%");}

//INPUTFIELD_548.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_549.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7OO5EC6O1LIN", {}));

//No. Satisfaction Score (Greated than 3)

INPUTFIELD_558.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00WNIH68", {}));

INPUTFIELD_559.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00WSMU7K", {}));

INPUTFIELD_557.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONUPHW3GAPE", {}));

INPUTFIELD_556.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00WXR78W", {}));

var T555 = DS_7.getData("62WHY1EOAR5NU7ONUPHW3GAPE", {}).value/10;

var A555 = DS_5.getData("62WHY1EOAR5PKI4GH00WXR78W", {}).value/10;

if (Convert.floatToString(A555,"#0.00") == '0.00') {INPUTFIELD_555.setValue("0%");}

else if  (Convert.floatToString(A555,"#0.00") != '0.00') {var P555 = (A555/T555)*100;INPUTFIELD_555.setValue(Convert.floatToString(P555,"#0.00")+"%");}

//INPUTFIELD_555.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_554.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONUPHVODQUQ", {}));

INPUTFIELD_552.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKI4GH00WICCXC", {}));

var T553 = DS_7.getData("62WHY1EOAR5NU7ONUPHVODQUQ", {}).value/10;

var A553 = DS_5.getData("62WHY1EOAR5PKI4GH00WICCXC", {}).value/10;

if (Convert.floatToString(A553,"#0.00") == '0.00') {INPUTFIELD_553.setValue("0%");}

else if  (Convert.floatToString(A553,"#0.00") != '0.00') {var P553 = (A553/T553)*100;INPUTFIELD_553.setValue(Convert.floatToString(P553,"#0.00")+"%");}

//INPUTFIELD_553.setValue(DS_5.getDataAsStringExt("62WHY1EOAR5PKAFQ6SLCWR8GD", {}));

INPUTFIELD_551.setValue(DS_7.getDataAsStringExt("62WHY1EOAR5NU7ONUPHVIJ1O2", {}));

layout:

TammyPowlas
Active Contributor
0 Kudos

Hi - it would help if you shared which version of Design Studio you are using; which version of the BI platform as well

IngoH
Active Contributor
0 Kudos

Hello Mohit,

you get over 130 script errors. Why don't you start by simply commenting out most of the script to narrow down which parts of the script is causing the issues ?

also the error log screens in Design Studio designer should help

regards

Ingo Hilgefort, Visual BI