# How to sum a value in a list data **URL:** \ **Category:** Database\ **Created:** [March 26, 2025, 2:55am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957 "2025-03-26T02:55:16Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Bamishey100](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Bamishey100](https://forum.adalo.com/u/Bamishey100)\ **Post date:** [March 26, 2025, 2:55am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/1 "2025-03-26T02:55:16Z")
Hi Guys, Im having issues getting total amount for the data pulled put from my collection as lis, I have try ‘New Formula’ option to add up field , but it’s not working, Any help will be appreciated. see screenshot below. ![report-err](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/0/2/0254ceaaa14e8ca9e1dd509b3ae021248a5d20af.png) ---
**Author:** ![Ali-Bazzi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ali-bazzi/32/40359_2.png) [@Ali-Bazzi](https://forum.adalo.com/u/Ali-Bazzi)\ **Post date:** [March 26, 2025, 7:11am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/2 "2025-03-26T07:11:09Z")
Hello, can you please share an image of the formula that you already have? Thank you! ---
**Author:** ![Bamishey100](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Bamishey100](https://forum.adalo.com/u/Bamishey100)\ **Post date:** [March 26, 2025, 7:44am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/3 "2025-03-26T07:44:40Z")
YES, PLEASE FIND MY SCREENSHOT ATTACHED, all im trying to do Is to get Total price for list of user cart collections. (Thanks) ![report-err--222](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/7/5/75fd4100326dd362f4e41dabb727ecfc89e3f7f9.png) ---
**Author:** ![Ali-Bazzi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ali-bazzi/32/40359_2.png) [@Ali-Bazzi](https://forum.adalo.com/u/Ali-Bazzi)\ **Post date:** [March 27, 2025, 7:30am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/4 "2025-03-27T07:30:47Z")
Thank you for attaching the image. Regarding the formula, in this case, it’s only showing one product pricing. In order to show the total price of a group of products in one collection, please follow these steps: - Add a collection in the database called (My\_cart orders) - Add a relationship (One to Many) between the (My\_cart) and (My\_cart orders). - Add a property in the (My\_cart orders) collection, and call it “Total price”. - Go to your (Add to cart) button, and add an action to create a (My\_cart order) record, then add the following formula into the new (Total price) property: (Current product price x Quantity). - Finally, we’ll go to the initial label of your formula, and please add the following calculations: (Logged in user =\> My\_cart =\> My\_cart orders =\> Total price =\> Sum). Please let me know if you have any questions. Thank you! ---
**Author:** ![Bamishey100](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Bamishey100](https://forum.adalo.com/u/Bamishey100)\ **Post date:** [March 27, 2025, 3:20pm UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/5 "2025-03-27T15:20:55Z")
Thank you brother, i will try this option and give you a feedback on how it goes… ---
**Author:** ![Bamishey100](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Bamishey100](https://forum.adalo.com/u/Bamishey100)\ **Post date:** [April 9, 2025, 5:37am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/6 "2025-04-09T05:37:55Z")
Thanks Man, it works with your Idea, with several workaround, Thanks man, Bless up ---
**Author:** ![Ali-Bazzi](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/ali-bazzi/32/40359_2.png) [@Ali-Bazzi](https://forum.adalo.com/u/Ali-Bazzi)\ **Post date:** [April 10, 2025, 7:03am UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/7 "2025-04-10T07:03:48Z")
Perfect, you’re welcome! I’m glad to hear that. ---
**Author:** ![Bamishey100](https://avatars.discourse-cdn.com/v4/letter/b/8edcca/32.png) [@Bamishey100](https://forum.adalo.com/u/Bamishey100)\ **Post date:** [April 10, 2025, 1:20pm UTC](https://forum.adalo.com/t/how-to-sum-a-value-in-a-list-data/54957/8 "2025-04-10T13:20:49Z")
Thank you so much, Is there a way to Display Data randomly in Adalo, i have list of data display in my app homepage, and i want the data to be displayed randomly to user each time the app refresh or each time user visit,