How to add a sum of 2 totals in a report

Shivan · February 20, 2016, 8:29am

Following the tutorial which gets the total made in each terminal. I’ve managed to set it up so it shows the sales made in each terminal, but I want to know how to now add both of these totals together get make a grand total made for the day?

Jesse · February 20, 2016, 1:43pm

Show your report template you used.

Shivan · February 21, 2016, 6:32am

This the report template

This is the report Script

sukasem · February 21, 2016, 7:15am

Just wondering isn’t Till1+Till2… = ticket payment total?

Shivan · February 21, 2016, 7:31am

I also noticed that when you check work period total, vs’s till total, they don’t match at all.

Here is what Work Period Shows for till 1

Here is what is captured from Till 1

It’s weird

sukasem · February 21, 2016, 7:35am

How about other till? Any payment on till2. Or your SQL query wrong.

Shivan · February 21, 2016, 7:42am

Nevermind actually, till 2 does show a different amount and they do equal the total amount in work period.

So in a sense It already does what I want it to do, I just got really confused, because I thought the work period showing on till 1 was seperate to work period on till 2.

So in other words, the work period report that shows the grand total, matches the exact amount that shows for till 1 and till 2 together.

Jesse · February 21, 2016, 1:34pm

Correct that report is for total venue. You could use REPORT PAYMENT DETAILS tag to build the same report as well.