Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jan 04, 2022 12:07 PM
Here’s one for you.
We have a purchase order for a job, with a total amount in one table.
We have multiple work shifts each be a varied amount depending on hours and rates of pay in another table.
I’d like to be able to summarise all shifts and subtract them from the total purchase order to check we are under budget.
Is this possible?
Jan 04, 2022 12:38 PM
Yes, this is possible, assuming that everything is joined with linked records.
I am picturing the following tables:
SUM(values)
)