Hi, I'm creating a form with a calculation that basically equals the "Large" function in Excel. For example, I need the 'Total' Field to be the sum of the 3 highest amounts from 4 amount fields. I've been looking everywhere for an example, but can't find anything. Is there any way to convert this formula to JavaScript?? I'm clueless! Thanks very much!
var arr = new Array(1, 2, 100, 45, 55, 66, 77); console.println('arry unsorted: ' + arr.join(', ') );var result = arr[1] + arr[2] + arr[3];console.println( result) // sort arrayarr.sort();console.println('array sorted: ' + arr.join(', ') );// compute resultvar result = arr[1] + arr[2] + arr[3];console.println( result)
// sort numeric descending compare functionfunction compareNumbersDescending(a, b) {return Number(b) - Number(a);}// end sort numeric descending compare function // Large funcitonfunction Large(aValues, nValues) {// returns the largest nValues from the array of vlaus aValues// sort the array aValuesaValues.sort(compareNumbersDescending);// compute the sum of the first nValuesvar sum = 0;for(i = 0; i < nValues; i++) {sum += Number(aValues[i]);}return sum; // return sum} // end Large Function // define an array of valuesvar arr = new Array(1, 2, 100, 45, 55, 66, 77, 5); console.println('arry unsorted: ' + arr.join(', ') );var result = arr[1] + arr[2] + arr[3];console.println( result) // sort arrayarr.sort();console.println('array sorted: ' + arr.join(', ') );// compute resultvar result = arr[1] + arr[2] + arr[3];console.println( result) // sort arrayarr.sort(compareNumbersDescending);console.println('array sorted numeric descending: ' + arr.join(', ') );// compute resultvar result = arr[0] + arr[1] + arr[2];console.println( result)// print large for various large n itemsconsole.println('Large 1: ' + Large(arr, 1) );console.println('Large 2: ' + Large(arr, 2) );console.println('Large 3: ' + Large(arr, 3) );console.println('Large 4: ' + Large(arr, 4) );console.println('Large 5: ' + Large(arr, 5) );console.println('Large 6: ' + Large(arr, 6) );console.println('Large 7: ' + Large(arr, 7) );console.println('Large 7: ' + Large(arr, 8) );
// sort numeric ascending compare functionfunction compareNumbers(a, b) {return Number(a) - Number(b);}// end sort numeric descending compare function // Large funcitonfunction Large(aValues, nValues) {// returns the largest nValues from the array of values aValues// sort the array aValuesaValues.sort(compareNumbers);// reverse the sort results - descending orderaValues.reverse();// compute the sum of the first nValuesvar sum = 0;for(i = 0; i < nValues; i++) {sum += Number(aValues[i]);}return sum; // return sum} // end Large Function
// build array of values to find the sum of the largest values fromvar fMyArray = new Array(this.getField('Total1').value,this.getField('Total2').value,this.getField('Total3').value,this.getField('Total4').value);// sum the 3 largest valuesevent.value = Large(fMyArray, 3); // sum the 3 largest values
You put them in an array, sort it, and then grab just the last 3 three items.
var arr = new Array(field1, field2, field3, field4);
arr.sort();
var result = arr[1]+arr[2]+arr[3];
- AcrobatUsers Community Expert - Contact me personally at try6767 [at] gmail [dot] com
Check out my custom-made scripts website: http://try67.blogspot.com