I have an app which is calculating delivery commissions paid to third party aggregators for the delivery of takeout.
I have three tables
(ONE: Delivery company and commission percent they charge,
TWO: Columns to add the delivery companies and their revenue for the day and
THREE: Totals per day)
These are linked together with a Ref and the user is able to enter the amount of revenue generated by the delivery company and it then calculates the commission and the remainder in the next two columns.
When the user adds the different delivery companies and their revenue I would like to update the totals table with the totals for the day.
I used the expressions below
SUM([Related Deliveries Daily Entries][Deliveries])
SUM([Related Deliveries Daily Entries][Delivery Commission])
SUM([Related Deliveries Daily Entries][Delivery Excluding Commission])
It is only returning the information from the first entry in my list rather than the total of the different entries of my list.
Where am I going wrong?
LinkedIn
Twitter
