# Ability to work in formula fields with results from formula fields on noloco tables

**URL:** <https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519>\
**Category:** Feature Requests\
**Created:** [April 8, 2024, 12:16pm UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519 "2024-04-08T12:16:45Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![JCW](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/jcw/32/173_2.png) [@JCW](https://community.noloco.io/u/JCW)\
**Post date:** [April 8, 2024, 12:16pm UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519/1 "2024-04-08T12:16:45Z")

</div>

A feature I am really desperately missing when using noloco tables is the ability to reference the results of other formula fields to be able to calculate based on their result. There are endles scenarios where this would be very useful…

---

<div class="post-metadata">

**Author:** ![akraut](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/akraut/32/63_2.png) [@akraut](https://community.noloco.io/u/akraut)\
**Post date:** [April 10, 2024, 2:20am UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519/2 "2024-04-10T02:20:41Z")

</div>

I had the same problem so I set up a database in Supabase where all the mathematical operations are performed. .

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [April 10, 2024, 1:42pm UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519/3 "2024-04-10T13:42:54Z")

</div>

Would also be nice to be able to use rollups in the formula. I have quite a simple formula that is Holidays (number) + Carried Days (number) - Rollup (SUM number)

---

<div class="post-metadata">

**Author:** ![darragh](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/darragh/32/12_2.png) [@darragh](https://community.noloco.io/u/darragh)\
**Post date:** [April 10, 2024, 3:08pm UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519/4 "2024-04-10T15:08:51Z")

</div>

@garyGHL you should be able to use rollups in a formula right now

 ![Screenshot 2024-04-10 at 15.36.17](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/3e709bcb9774ebbcf4e628d1b286b1009ff650d2.png)

---

<div class="post-metadata">

**Author:** ![garyGHL](https://dub1.discourse-cdn.com/flex005/user_avatar/community.noloco.io/garyghl/32/555_2.png) [@garyGHL](https://community.noloco.io/u/garyGHL)\
**Post date:** [April 10, 2024, 3:30pm UTC](https://community.noloco.io/t/ability-to-work-in-formula-fields-with-results-from-formula-fields-on-noloco-tables/519/5 "2024-04-10T15:30:21Z")

</div>

@darragh . Its an odd one, it works when I first create the formula but once a record is updated it starts to display odd numbers. Below, Holiday Taken is the rollup field:

Fields:  
HR Allocation = 12  
HI Carried = 2  
Holiday Taken = 11

Formula should read 12+2-11 = 3 but actually displays -11

 ![image](https://europe1.discourse-cdn.com/flex005/uploads/noloco/original/1X/43901beb6d9bd3403d826f64c4cb0eaf44f847d8.png)