Hi I am making a food booking app where , different company staff add the item to the cart. Once every staff has added the item to cart , A company admin submit the order. I am collecting all the orders by different companies in one sheet (mycart) . when company need to pay , i need to show SubTotal amount at that page. But i am unable to do sum for that specific company. I tried , template, relation, roll up referring to the previous topics here but still could not succeed. Any help is appreciated. [Screenshot 2024-09-20 at 08.19.10] [Screenshot 2024-09-20 at 08.17.32]

Create a relation column that matches the Company name with itself Do a Rollup->Sum->Price via that relation

Hi Darren Thanks. i got hang off it now. However i had one additional question. How can I do sum for different dates and different company .

It’s similar, except when you want to match multiple criteria you should use a Query column instead of a relation. Also, when working with dates in this way it’s best to first convert them to integers using a math column. So, to sum by Company and Date: Start with a Math column using the following formula: Year(Date)*10^4 +Month(Date)*10^2 +Day(Date) Substitute “Date” in that formula with your Date column. That will give you an integer representation of the date in YYYYMMDD format Next create a Query column that targets your table and apply the following filters: – Company is This row->Company – (math) Date is This row->(math) Date Finally, do a rollup->sum via the Query

Hi Darren Thanks for quick reply. I implemented as you suggested but it did not sum for same company for same date. See attached picture. For company A it did not work. But for company B it did worked. Am i missing something. [Screenshot 2024-09-22 at 17.47.32]

You skipped the step to convert your date into a YYYYMMDD integer. You need to consider that your date columns have an underlying time that differs on each row.

Hi Darren i found error, Its fine now. I used non math date column. I have additional question . How can i filter out duplicate values from the rollup column. Same date values for same company. [Screenshot 2024-09-22 at 18.01.22]

[image] Filter to display DISTINCT (or Unique) rows based on specified columns Feature Requests I typically use or recommend the following method: Make sure there is a Row ID column. Create a single Relation or Query to link similar rows to themselves based on similar values. Create a Lookup or Single Value column to retrieve the first matching Row ID from the Relation/Query. Finally create an IF column comparing the row’s Row ID to the Lookup/Single Value column and return true if there is a match. Only the first occurrence will be a match.

Hi Jeff I tried as per your suggestion above. However it does not single out same rows. It says true to all rows. [Screenshot 2024-09-23 at 18.44.18]

You already have a query column to handle the grouping. You should be using that and just adding a Single Value column to get the first RowID from each group.

Thanks Jeff It worked. I got them sorted. Now i need to figure out how to show them when user login and click them. It was good learning about relation, query so on.

Summation of values in rows for specific row

Ask for Help

Jeff_Hager September 22, 2024, 9:47pm 8

Topic		Replies	Views
How to get total of rows based on a column value? Ask for Help	8	1597	March 7, 2021
How to a SUM for each specific row and not the entire column? Ask for Help	4	882	April 18, 2020
Dynamic Sum based on other columns values Ask for Help	8	306	November 23, 2023
Help in sum by date and label Ask for Help	7	85	February 17, 2025
Sum Values for each Row Using Rollup Ask for Help	15	3626	October 3, 2020

Summation of values in rows for specific row

Related topics