Re: Is there any functions like the function Large in Excel?

1404 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hey here,

I’m tring to find the second to the max value of a array, but i can’t find any functions like Large in Excel.
Is there any way to implement this function?
Thanks for your help

2 Replies 2
7 - App Architect
7 - App Architect

I’m not sure how you could do it with a formula field but in an automation you could use

function secondLast(array) {
  return - 2)


Thanks! And i have tried to deal with it by using some js scripts :grinning_face_with_smiling_eyes:

`let mainTable = base.getTable(“list”);
let mainTableRecords = await mainTable.selectRecordsAsync({fields:[“volume”,“cal”]});
let mainTableSum =await mainTable.selectRecordsAsync({fields:[“cal”]});
for (let record of mainTableRecords.records) {
let recordget= record.getCellValue(“volume”);
var sumval= recordget[0]+recordget[1];

    await mainTable.updateRecordAsync(record, {
            "cal": sumval