It would be really useful if formulas could consider only a certain number of records based on the records. For instance, if I could choose only to average the most recent 3 records. I don't believe this is possible at present.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Feature: "Most recent" option in calculated field | 3 | 592 | October 19, 2015 | |
| Show a Warning as soon as Knack forgets how to count | 0 | 371 | June 26, 2019 | |
| Tables - number of records | 2 | 359 | August 7, 2017 | |
| How do I create a field that has individual formulas per record? | 3 | 408 | August 31, 2021 | |
| Show 5 records | 0 | 277 | March 14, 2016 |