In Acrobat Pro X, I can execute javascript calcultion with a variable in drop down list, but it does'nt work in LC
In Drop down list calculation
function TaxeRang1(suffixe) {
rang = 1 * getField("Total_km" + suffixe).value + 1 * getField("Transport" + suffixe).value + 1 * getField("Logement" + suffixe).value + 1 * getField("Repas_FF" + suffixe).value + 1 * getField("Autres" + suffixe).value;
rangFD = 1 * getField("Logement" + suffixe).value + 1 * getField("Autres" + suffixe).value
if (event.value == "QC") {
rang1QC = rang;
rang1ON = rang1CB = rang1NE = rang1NB = rang1TN = 0;
rang1FDQC = rangFD;
rang1FDON = rang1FDCB = rang1FDNE = rang1FDNB = rang1FDTN = 0;
}
if (event.value == "ON") {
rang1ON = rang;
rang1QC = rang1CB = rang1NE = rang1NB = rang1TN = 0;
rang1FDON = rangFD;
rang1FDQC = rang1FDCB = rang1FDNE = rang1FDNB = rang1FDTN = 0;
}
if (event.value == "CB") {
rang1CB = rang;
rang1ON = rang1QC = rang1NE = rang1NB = rang1TN = 0;
rang1FDCB = rangFD;
rang1FDON = rang1FDQC = rang1FDNE = rang1FDNB = rang1FDTN = 0;
}
if (event.value == "NE") {
rang1NE = rang;
rang1ON = rang1QC = rang1CB = rang1NB = rang1TN = 0;
rang1FDNE = rangFD;
rang1FDON = rang1FDCB = rang1FDQC = rang1FDNB = rang1FDTN = 0;
}
if (event.value == "NB") {
rang1NB = rang;
rang1ON = rang1QC = rang1CB = rang1NE = rang1TN = 0;
rang1FDNB = rangFD;
rang1FDON = rang1FDCB = rang1FDNE = rang1FDQC = rang1FDTN = 0;
}
if (event.value == "TN") {
rang1TN = rang;
rang1ON = rang1QC = rang1CB = rang1NE = rang1NB = 0;
rang1FDTN = rangFD;
rang1FDON = rang1FDCB = rang1FDNE = rang1FDNB = rang1FDQC = 0;
}
if (event.value == "EX") {
rang1QC = rang1ON = rang1CB = rang1NE = rang1NB = rang1TN = 0;
rang1FDQC = rang1FDON = rang1FDCB = rang1FDNE = rang1FDNB = rang1FDTN = 0;
}
}
TaxeRang1("_01");
result field : DepQC
event.value = 1 * rang1QC + 1 * rang2QC + 1 * rang3QC + 1 * rang4QC + 1 * rang5QC + 1 * rang6QC + 1 * rang7QC + 1 * rang8QC + 1 * rang9QC + 1 * rang10QC + 1 * rang11QC + 1 * rang12QC + 1 * rang13QC + 1 * rang14QC + 1 * rang15QC + 1 * rang16QC + 1 * rang17QC + 1 * rang18QC + 1 * rang19QC + 1 * rang20QC + 1 * rang21QC + 1 * rang22QC + 1 * rang23QC + 1 * rang24QC + 1 * rang25QC + 1 * rang26QC
TotalTaxables = 1 * event.value + getField("DepON").value + getField("DepCB").value + getField("DepNE").value + getField("DepNBTN").value
getField("TotalDepTPS").value=getField("TotalDepTPSA").value=1*event.value
getField("TotalDepTVH").value = TotalTaxables - event.value
getField("Grand_Total_Taxables").value = TotalTaxables
getField("Total_SansTaxes").value = getField("Grand_Total").value - TotalTaxables
if (TotalTaxables == 0) {
PourcentageNUM=0
getField("TxRatio").value = 0
} else {
PourcentageNUM=100*event.value / TotalTaxables
getField("TxRatio").value = event.value / TotalTaxables
getField("TxRatioTVH").value = (1 - (event.value / TotalTaxables))
}
result field : DepON
event.value=1*rang1ON+1*rang2ON+1*rang3ON+1*rang4ON+1*rang5ON+1*rang6ON+1*rang7ON+1*rang8ON+1*rang9ON+1*rang10ON+1*rang11ON+1*rang12ON+1*rang13ON+1*rang14ON+1*rang15ON+1*rang16ON+1*rang17ON+1*rang18ON+1*rang19ON+1*rang20ON+1*rang21ON+1*rang22ON+1*rang23ON+1*rang24ON+1*rang25ON+1*rang26ON
getField("TotalDepON").value=event.value
