How to sum a value in a list data

Get Help Database
1

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
report-err796×902 51.4 KB

2

Hello, can you please share an image of the formula that you already have?

Thank you!

3

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
report-err--222730×949 46.8 KB

4

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!

5

Thank you brother, i will try this option and give you a feedback on how it goes…