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 SubTot…

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…

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 va…

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	1586	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	302	November 23, 2023
Help in sum by date and label Ask for Help	7	84	February 17, 2025
Sum Values for each Row Using Rollup Ask for Help	15	3607	October 3, 2020

Summation of values in rows for specific row

Related topics