# Rollup Column without 0 **URL:** \ **Category:** Ask for Help\ **Created:** [June 21, 2024, 10:46am UTC](https://community.glideapps.com/t/rollup-column-without-0/74297 "2024-06-21T10:46:37Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Fabian\_Klein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabian_klein/32/64481_2.png) [@Fabian\_Klein](https://community.glideapps.com/u/Fabian_Klein)\ **Post date:** [June 21, 2024, 10:46am UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/1 "2024-06-21T10:46:37Z")
Hi. I am a total amateur, but I want to create a rollup column in which all numbers from a different table (Glide tables) are included, but not those where the original number is 0. Specifically: One table features all wines in a cellar, including how many bottles are on stock (2 bottles of wine A, 5 of wine b, 3 of wine c, 0 of wine d). In the rollup column, I want to get the number of different wines in the cellar (not the number of bottles), so the “correct” number I am looking for is in the example would be 3 (since only 3 are in stock), not 4 (because one is listed with zero bottles), and not 10 (which would be the number of bottles in stock). Any help / idea would be much appreciated! Thanks! ---
**Author:** ![Eitan](https://avatars.discourse-cdn.com/v4/letter/e/aca169/32.png) [@Eitan](https://community.glideapps.com/u/Eitan)\ **Post date:** [June 21, 2024, 11:00am UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/2 "2024-06-21T11:00:05Z")
I would make a query column on the table where you want to pull the data and set its source to be the target table Then you can add filters to that query such that the specified column must be greater than 0 etc etc Then you can perform a roll up on that query column … hope that helps! ---
**Author:** ![Fabian\_Klein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabian_klein/32/64481_2.png) [@Fabian\_Klein](https://community.glideapps.com/u/Fabian_Klein)\ **Post date:** [June 21, 2024, 2:07pm UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/3 "2024-06-21T14:07:57Z")
Thanks, Eitan. But when I create a query column, I do not get numbers in there but names / pictures. And when I then create a rollup column, it does not let me choose the query column as source… So I am afraid it is not working. ---
**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\ **Post date:** [June 21, 2024, 2:33pm UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/4 "2024-06-21T14:33:09Z")
You can use the If-Else column in the source table to convert the number 0 to empty. This way your rollup will not be added up. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [June 21, 2024, 6:55pm UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/5 "2024-06-21T18:55:08Z")
> [@Fabian\_Klein](#): > > when I create a query column, I do not get numbers in there but names / pictures What a query or relation shows is irrelevant. They both create links to ROWS. If you see anything in those types of columns, it’s just telling you that it found matching row. From there a Rollup columns and a handful of other columns can look into those related rows and pull out specific column values. > [@Fabian\_Klein](#): > > it does not let me choose the query column as source Are you creating the Rollup in the same table where you created the query? Look closely, the Query column should be listed above or below your list of tables. Don’t try to find the query by going to the table first. ---
**Author:** ![Fabian\_Klein](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/fabian_klein/32/64481_2.png) [@Fabian\_Klein](https://community.glideapps.com/u/Fabian_Klein)\ **Post date:** [June 25, 2024, 12:08pm UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/6 "2024-06-25T12:08:24Z")
Yippie! thanks for pointing me in the right direction, got it now! ---
**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:** [July 2, 2024, 12:08pm UTC](https://community.glideapps.com/t/rollup-column-without-0/74297/7 "2024-07-02T12:08:39Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.