# I want a split bill calculator based on multiple users

**URL:** <https://community.glideapps.com/t/i-want-a-split-bill-calculator-based-on-multiple-users/16619>\
**Category:** Ask for Help\
**Created:** [October 1, 2020, 3:45pm UTC](https://community.glideapps.com/t/i-want-a-split-bill-calculator-based-on-multiple-users/16619 "2020-10-01T15:45:55Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Emma\_Marslan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/emma_marslan/32/415_2.png) [@Emma\_Marslan](https://community.glideapps.com/u/Emma_Marslan)\
**Post date:** [October 1, 2020, 3:45pm UTC](https://community.glideapps.com/t/i-want-a-split-bill-calculator-based-on-multiple-users/16619/1 "2020-10-01T15:45:55Z")

</div>

The spreadsheet I have is set correctly, now I want to show points and percentages based on user input.

 ![Screenshot 2020-10-01 at 16.43.01](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/565e3e91d18b49267d539e8c2805a42344715691.png)

Example:

**User 1** fills in how much they have paid for gas, tax, electricity, water and rent and now I want them to see how many points they have and percentage.

The point of the app is so flat mates see what parts of bills are paid in total

---

<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:** [October 1, 2020, 4:28pm UTC](https://community.glideapps.com/t/i-want-a-split-bill-calculator-based-on-multiple-users/16619/2 "2020-10-01T16:28:10Z")

</div>

For the points, you can use a math column to sum all cols from Gas to Water.

For the percentage, first, make a rollup column on the points column to get the sum. Then make a math col, divide points by rollup total times 100 to get the percentage.