# Rollup/Lookup returns all CBM values instead of single one

**URL:** <https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716>\
**Category:** Ask for Help\
**Created:** [October 3, 2025, 6:13am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716 "2025-10-03T06:13:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kristaps\_Lagzdins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kristaps_lagzdins/32/92158_2.png) [@Kristaps\_Lagzdins](https://community.glideapps.com/u/Kristaps_Lagzdins)\
**Post date:** [October 3, 2025, 6:13am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716/1 "2025-10-03T06:13:38Z")

</div>

Hi everyone,

I’m building an app to calculate log weights inside containers.  
I have two tables:

- **CBM Table** – contains CBM values for each `Key = Diameter + Length`.
- **Koki Table** – each row is a log, with a `Key` column that should match exactly one row in the CBM Table.

I created a **Relation (CBM Ref)** between `Koki.Key` and `CBM.Key`.  
That works — it finds the correct match (e.g. `20 - 4000`).

Problem:  
When I create a **Lookup** or **Rollup** , it shows _all values_ from the CBM table instead of just the one that matches.  
For example, instead of just `0.147`, I get `{0.047, 0.052, 0.061, 0.069, 0.147, …}`.

I expected only one value, since the key is unique.

**Question:**

- Why is Glide not returning only one row from the relation?
- Do I need to change data type (number vs text)?
- Or is there some trick with Rollup → “Single value” to only return one CBM?

Thanks in advance 🙏

Pictures of my tables:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/f/7f17fe35ac766518fa7a12ced682737bb5589032.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/8/c803b377d20beea67a394677230aad6cc071b940.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/6/b681be23f55ad196cae5cba1471471ce660ed288.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 3, 2025, 6:27am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716/2 "2025-10-03T06:27:03Z")

</div>

Are you sure you are targeting the relation correctly?  
Can you show how your CBM lookup is configured?

---

<div class="post-metadata">

**Author:** ![Kristaps\_Lagzdins](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kristaps_lagzdins/32/92158_2.png) [@Kristaps\_Lagzdins](https://community.glideapps.com/u/Kristaps_Lagzdins)\
**Post date:** [October 3, 2025, 6:28am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716/3 "2025-10-03T06:28:05Z")

</div>

You mean this one?

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/e/fe295e32ffd761f3896dc414e10d9efe7e5186bd.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [October 3, 2025, 6:29am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716/4 "2025-10-03T06:29:21Z")

</div>

Yes, that’s the problem. You are targeting the CBM column through the table, instead of through the relation, essentially ignoring the relation. Change that and you should get the result you are expecting.

 ![CleanShot 2025-10-03 at 14.47.46@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c71a0f6af94d363b0b1b8aa7e89ebfa341fd293a.png)

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [October 10, 2025, 6:30am UTC](https://community.glideapps.com/t/rollup-lookup-returns-all-cbm-values-instead-of-single-one/84716/5 "2025-10-10T06:30:11Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.