I have a problem with data manipulation when grouping records on a date range.
Each record has a date and a time, (they are cash receipts linked to a cash register). Of course I have multiple records per day.
I want to group these records by day and verify the data via another table (the cash register verification table).
To group my records on a date range I have no problem (I used formulas of type DATETIME_FORMAT(Date, "DD/MM/YYYY ")).
On the other hand I want to use the sum of each day and link this sum in another table of my database and I can’t do it with the rollup because it considers the records unique and not grouped.
In short, on the one hand I have customers who buy, and on the other hand I want to do a data validation on the totals of several columns per day and this without having to link via a rollup each record of each customer.
Thanks for your help.
Hi Martin, I’m not sure if I fully understand your problem here
Could we link up the records with the
DATETIME_FORMAT(Date, "DD/MM/YYYY ") value instead? That way they’ll be linked together by day and you’ll be able to do a rollup to get the sum like you want
Hi Adam, yes that is perfect. I made an automation to automatically complete the linked record from the date. And with the rollups it works perfectly.
Thank a lot
This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.