# Control what records formulas consider

**URL:** https://forums.knack.com/t/control-what-records-formulas-consider/5689
**Category:** Feature Requests
**Created:** [June 6, 2015, 2:41pm UTC](https://forums.knack.com/t/control-what-records-formulas-consider/5689 "2015-06-06T14:41:00Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![JamesNaylo85945](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jamesnaylo85945/32/166_2.png) [@JamesNaylo85945](https://forums.knack.com/u/JamesNaylo85945)
#### Post date: [June 6, 2015, 2:41pm UTC](https://forums.knack.com/t/control-what-records-formulas-consider/5689/1 "2015-06-06T14:41:00Z")

</div>

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.

---

<div class="post-metadata">

### Author: ![Jessie](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/jessie/32/5_2.png) [@Jessie](https://forums.knack.com/u/Jessie)
#### Post date: [July 15, 2021, 8:03pm UTC](https://forums.knack.com/t/control-what-records-formulas-consider/5689/2 "2021-07-15T20:03:20Z")

</div>