# Issue with Price Point Selection ($,$$,$$$,$$$$)

**URL:** https://community.glideapps.com/t/issue-with-price-point-selection/38223
**Category:** Ask for Help
**Created:** [February 7, 2022, 5:46pm UTC](https://community.glideapps.com/t/issue-with-price-point-selection/38223 "2022-02-07T17:46:40Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)
#### Post date: [February 7, 2022, 5:46pm UTC](https://community.glideapps.com/t/issue-with-price-point-selection/38223/1 "2022-02-07T17:46:40Z")

</div>

I have a filter category for finding businesses at 1 of 4 different price points. It’s the typical array of options you would see in a marketplace:

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

I have my filter set to “When price point INCLUDES Price Point Selection” because I want ALL businesses to show before the price is selected and it’s just on the dash ( - ). If I changed it to “Price IS…” no businesses would show until selection is made.

BUT because I have it set to INCLUDES instead of IS, when a user selects anything less than the highest ($$$$), it will include anything greater than the selection.

EX: User selects ($) it will show businesses at $ and $$ and $$$ and $$$$  
User selects ($$$) it will show businesses rated at $$$ and $$$$

What can I add to my database so that the ($) reads as a specific setting or number? I’ve tried to add a math column but I’m not doing it right.

---

<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: [February 7, 2022, 6:12pm UTC](https://community.glideapps.com/t/issue-with-price-point-selection/38223/2 "2022-02-07T18:12:41Z")

</div>

There are a couple of ways you could do this, but here is what I would recommend:

- In the table that contains all the price point data, create a [Single Value](https://docs.glideapps.com/all/topics/computed-columns/primary/single-value-column) column. This column should take the value from the column that your choice component is writing to, and apply it to all rows.
- Next create an [if-then-else](https://docs.glideapps.com/all/topics/computed-columns/primary/if-then-else) column, using the following logic:  
– If Single Value column is empty, then `true` (this will cover the case where they don’t select anything)  
– Else if price point is single value column, then `true`
- Now you can apply a filter to your Inline List, only showing those rows where the if-then-else column is `true`

---

<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: [February 8, 2022, 6:13pm UTC](https://community.glideapps.com/t/issue-with-price-point-selection/38223/3 "2022-02-08T18:13:22Z")

</div>

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