# Reduce percentage

**URL:** <https://community.glideapps.com/t/reduce-percentage/62603>\
**Category:** Ask for Help\
**Created:** [June 9, 2023, 5:16pm UTC](https://community.glideapps.com/t/reduce-percentage/62603 "2023-06-09T17:16:26Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [June 9, 2023, 5:16pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/1 "2023-06-09T17:16:26Z")

</div>

Hi  
I tried reducing the percentage of 28% -2% but the result was 0.26  
the result i want is 26%, because if the result is 0.26 glide doesn’t allow that adder.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/33f275d790dda6b4f7787ab0538e18975932d49f.png)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/7/575f50be7e110973699bb0276bad7794a3c13f4b.png)

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 9, 2023, 5:39pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/2 "2023-06-09T17:39:36Z")

</div>

> [@agung\_Taufik](#):
>
> I tried reducing the percentage of 28% -2% but the result was 0.26
> 
> the result i want is 26%

…X 100

---

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [June 9, 2023, 6:10pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/3 "2023-06-09T18:10:01Z")

</div>

> [@Eric\_Penn](#):
>
> …X 100

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a42a9d448b2c1f526db18c8dad5003b0ae85a9b6.png)  
Is it like this?

---

<div class="post-metadata">

**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 9, 2023, 6:15pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/4 "2023-06-09T18:15:26Z")

</div>

Math order of operations. Make sure you use parentheses so the subtraction happens before the multiplication.

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [June 9, 2023, 6:16pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/5 "2023-06-09T18:16:02Z")

</div>

(x-y)\*100

---

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [June 9, 2023, 6:23pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/6 "2023-06-09T18:23:41Z")

</div>

ok already, how to convert the result into a percentage?

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

---

<div class="post-metadata">

**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 9, 2023, 6:35pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/7 "2023-06-09T18:35:53Z")

</div>

0.26 is actually the equivalent of 26%, but if you just want the percent symbol, you can add that as a Unit in your math column.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [June 9, 2023, 8:53pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/8 "2023-06-09T20:53:30Z")

</div>

your missing key is this

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

---

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [June 9, 2023, 10:39pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/9 "2023-06-09T22:39:19Z")

</div>

> [@Jeff\_Hager](#):
>
> 0,26 sebenarnya setara dengan 26%

Yes I know  
but why glide does not allow such calculations?

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

---

<div class="post-metadata">

**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 9, 2023, 11:05pm UTC](https://community.glideapps.com/t/reduce-percentage/62603/10 "2023-06-09T23:05:04Z")

</div>

That error has nothing to do with using a percent in your calculation.

You have a circular dependency. The result of your math column is being used somewhere else to calculate the values used in the replacements for your math column. The math result is being used to calculate the result of the math. It’s an endless loop that would crash your app if it was allowed to happen.

Google sheets can allow circular dependencies, but usually stops after something like 100 loops. Glide on the other hand does not allow for circular dependencies. I think you may be trying to use the wrong values for your calculation.

I guess it looks like you are trying to use Flash Sale to calculate Flash Sale.
