Hi Andrew

I would use the function slice instead to select the last 6 records https://docs.ninox.com/en/script/functions/slice

let a := select Table1;
let b := count(a);
let c := slice(a,b-6,b);

avg((c).cost)

My understanding that if you don't specify an order then it will be in Id order.

Regards John