Search Knowledge Base by Keyword

Median Function

Goal:

Calculate a median amount from numbers inserted to Text Inputs in a Document or Bundled Documents.

Instructions:

  1. Create the Template tag Median and attach this tag to all Text Inputs in your Template that should be calculated.
  2. Create the Template tag GetMedianValue and attach this tag to the Text Input in your Template where the sum amount should be inserted.
  3. Insert the below-mentioned script to the Median tag.

Script Example:

const Tags = LEGITO.documentBuilder.getTagsByName("Median");

 

var finder = LEGITO.documentBuilder.event.createElementFinder();
var medianValues = finder.findElementsByTagsAuto(Tags);

 

const Results = LEGITO.documentBuilder.getTagsByName("GetMedianValue");
var resultElement = finder.findElementsByTagsAuto(Results)[0];

 

let valuesArray = []
for(var i in medianValues) {
if(medianValues[i].getValue() !== null) {
valuesArray.push(parseInt(medianValues[i].getValue(), 10));
}
}

 

function median(values){
if(values.length ===0) return 0;

 

values.sort(function(a,b){
return a-b;
});

 

var half = Math.floor(values.length / 2);

 

if (values.length % 2)
return values[half];

 

return (values[half - 1] + values[half]) / 2.0;
}

 

resultElement.setValue(median(valuesArray).toString());