on 02-22-2016 10:26 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please have a look at replies to similar threads/questions:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.