Comparing 2 scoring fields

Score arithmetic and aggregation was one of the initial inspirations for FlowBoost.

A short recipe:

var scores = [
  { type: 'behavioral', score: {{Lead.Behavioral Score}} },
  { type: 'demographic', score: {{Lead.Demographic Score}} },
  { type: 'firmographic', score: {{Lead.Firmographic Score}} },
  { type: 'psychographic', score: {{Lead.Psychographic Score}} }
],
highScore = getMax(scores,'score');
function getMax(coll, sortBy){
  return coll.concat().sort(function sortAsc(l,r){
    return sortBy ? l[sortBy] - r[sortBy] : l - r;
  }).pop();
}

(Note in this implementation a tie goes to the later entry in the set of scores, i.e. if Firmographic and Psychographic are both 90, then Psychographic is returned. So you can use the order to determine which one has "seniority.")

Hi Fab Capodicasa​, your app looks great! can I do this with it?

=INDEX(A1:D1,MATCH(MAX(A2:D2),A2:D2,0))

The Excel table looks like that:

Also, if there are equal fields it will return the first one it finds.

Thanks!

That's not actually true. We use very high volume Webhooks, 140/minute for real-time scoring