# How can I show percentage increase?

**URL:** <https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462>\
**Category:** Ask for Help\
**Created:** [April 30, 2022, 2:42pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462 "2022-04-30T14:42:47Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 30, 2022, 2:42pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/1 "2022-04-30T14:42:47Z")

</div>

Hi folks 👋

I’m trying to build a specific feature for a fitness app concept in Glide.

Upon entering a new workout for a given exercise, I want to display the percentage increase in volume (weight X reps) for each exercise since the first set. I can do this for one exercise by specifying the first volume as the starting one against which all the others should be measured. However, the problem I have is that _every_ exercise is then measured against the volume of the first exercise, e.g. benchpress sets are measured against the first squat workout.

Does anybody know how I might achieve this for each exercise?

 ![Screenshot 2022-04-30 at 15.41.53](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/4/7413d3ec3302b4f2166c1dde164ae23c1a5cdc57.png)

---

<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:** [April 30, 2022, 3:10pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/2 "2022-04-30T15:10:54Z")

</div>

What’s the configuration on that Single Value column?  
It looks like you’re taking the first value from the previous column.  
I suspect what you need to do is take the value via the “Related exercise” column (the 2nd column).

---

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 30, 2022, 5:55pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/3 "2022-04-30T17:55:52Z")

</div>

That’s correct. I’m taking the first value from ‘Volume’, which is only suitable for sets of the same exercise. The Volume is Weight X Reps, in this same sheet.

Do you know how I would take the _first volume_ for each exercise via the ‘Related exercise’ relation column?

---

<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:** [April 30, 2022, 6:05pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/4 "2022-04-30T18:05:51Z")

</div>

Well, assuming that column is a multiple relation that relates each exercise to itself, it should just be a matter of reconfiguring the single value column to take the first volume value via that relation.

If that’s not what it is, then we might need a bit more information.

---

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 30, 2022, 6:09pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/5 "2022-04-30T18:09:07Z")

</div>

Hmmmm I think I get where you’re coming from. I’ll take a stab at it and let you know what I come up with to see if it’s what you meant 🙏

---

<div class="post-metadata">

**Author:** ![Hawki](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hawki/32/42137_2.png) [@Hawki](https://community.glideapps.com/u/Hawki)\
**Post date:** [April 30, 2022, 6:22pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/6 "2022-04-30T18:22:57Z")

</div>

Nice. I’ve used a lookup function to look up what the starting (weight X rep) is. Thanks Darren! 👏

---

<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:** [April 30, 2022, 6:24pm UTC](https://community.glideapps.com/t/how-can-i-show-percentage-increase/41462/7 "2022-04-30T18:24:58Z")

</div>

Okay, so it must be a single relation. The lookup works for you here (by accident) because a single relation will return the first matching row, which in this case is exactly what you need.
