# MIN / MAX in a single value column

**URL:** <https://community.glideapps.com/t/min-max-in-a-single-value-column/72647>\
**Category:** Ask for Help\
**Created:** [April 17, 2024, 9:40am UTC](https://community.glideapps.com/t/min-max-in-a-single-value-column/72647 "2024-04-17T09:40:27Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![EPS\_Simonin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eps_simonin/32/62668_2.png) [@EPS\_Simonin](https://community.glideapps.com/u/EPS_Simonin)\
**Post date:** [April 17, 2024, 9:40am UTC](https://community.glideapps.com/t/min-max-in-a-single-value-column/72647/1 "2024-04-17T09:40:27Z")

</div>

Hi everyone  
i want to create a standard deviation or Min / max calculation from a single value column but i can’t. Can you tell me if there’s a trick to allow this ?  
I used the miracle method of Robert Pettito to transpose row into column but i’m stuck at this point.

 ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e2bf290cf6c54caf79fc3af8ea35c5bcd9f08b3.jpeg)  
 ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/9/a9e10388ab47c85c551913a5935eb7f74649178c.jpeg)

thanks for help  
PS

---

<div class="post-metadata">

**Author:** ![tuzin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tuzin/32/86077_2.png) [@tuzin](https://community.glideapps.com/u/tuzin)\
**Post date:** [April 17, 2024, 11:57am UTC](https://community.glideapps.com/t/min-max-in-a-single-value-column/72647/2 "2024-04-17T11:57:25Z")

</div>

It seems like the array is coming from a string, which makes all the array elements strings, not numbers

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [April 17, 2024, 12:01pm UTC](https://community.glideapps.com/t/min-max-in-a-single-value-column/72647/3 "2024-04-17T12:01:17Z")

</div>

Exactly. There’s a trick you can do to convert a string value into a number value. Use a math column and enter `0+0+ variable` with that variable is the value you want to convert.

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 17, 2024, 11:21pm UTC](https://community.glideapps.com/t/min-max-in-a-single-value-column/72647/4 "2024-04-17T23:21:05Z")

</div>

Haven’t tried, but maybe `variable*1` also works.

If `0+0+ variable` doesn’t work, try `-0+0+ variable`.