# Filtering Choice component by computed column **URL:** \ **Category:** Ask for Help\ **Created:** [September 7, 2023, 9:19am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869 "2023-09-07T09:19:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\ **Post date:** [September 7, 2023, 9:19am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/1 "2023-09-07T09:19:50Z")
Hello! I’m trying to filter a Choice Component using a math column, but it’s not working. What I really want to do is create a simple inventory quantity calculator and exclude items with zero quantity from selection. Next to the math column I have a numeric column with seed quantities, and if I try to filter on that column manually by changing the seed quantities, it works correctly. Is this a bug or am I doing something wrong? ---
**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:** [September 7, 2023, 9:26am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/2 "2023-09-07T09:26:06Z")
Can you elaborate a bit on the math column? Specifically, does it use values from any other tables? And if yes, do any of those tables have row owners applied anywhere? ---
**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\ **Post date:** [September 7, 2023, 10:20am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/3 "2023-09-07T10:20:08Z")
Hi Darren\_Murphy thanks for your prompt response! The math column calculates the inventory balance based on daily sales volume. In turn, the sales amount is summed from the sales that are retrieved from the sales table through the relay component. In the sales table, the user’s email address is row owner. All tables have a row ID column. ---
**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:** [September 7, 2023, 10:22am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/4 "2023-09-07T10:22:21Z")
Okay, so my guess is that Row Owner column in the Sales table is what’s tripping things up. You can confirm that temporarily removing it, and see it that changes anything. ---
**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\ **Post date:** [September 7, 2023, 10:37am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/5 "2023-09-07T10:37:56Z")
Yes, Darren\_Murphy you are right! Now it works. It remains only to find out whether there will be negative consequences in other places after the removal of the Row Owner from Email Thanks a lot for your help! ---
**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:** [September 7, 2023, 10:47am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/6 "2023-09-07T10:47:12Z")
The effect of Row Owners is that each users device will only get those rows that the signed in user “owns”. This is why your math column wasn’t working. It’s a computed column, which means that the result is evaluated locally on each users device, and because each user gets a different set of rows, then each user gets a different result. Removing it means that each user gets _all_ rows. That’s normally only an issue if there is sensitive/private data involved. One side effect of removing it that you might need to check is if you were relying on Row Owners to filter rows, that won’t work any more. So you might have to add some “email is signed in user” filters. ---
**Author:** ![Swellart](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/swellart/32/6118_2.png) [@Swellart](https://community.glideapps.com/u/Swellart)\ **Post date:** [September 7, 2023, 11:04am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/7 "2023-09-07T11:04:52Z")
Thank you one more time Darren\_Murphy! I already see it and started to add additional filters. ---
**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:** [September 14, 2023, 11:05am UTC](https://community.glideapps.com/t/filtering-choice-component-by-computed-column/65869/8 "2023-09-14T11:05:05Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.