How to create a column for subtotal plus the tax in Atrex 15 daily sales overview?
Question asked by Aziz Ranzoorpal - July 2, 2015 at 4:10 PM
Hi everyone
On the daily sales overview report, it shows the subtotal and tax on two different columns. I need another column that will have a header, add the subtotal and tax together for each sale and then have the sum of it on the summary in the bottom on daily sales report. How do I do this? I tried the Db calculator but can't seem to get the correct results. I get zeros for all the whole column.
Thanks for your help

1 Reply

Reply to Thread
Terry Swiers Replied
July 2, 2015 at 4:35 PM
Employee Post
There are two ways to do this.

The first is to is let the database engine calculate a new field that combines the two fields and then report on that.  On the data tab, add a new field to the calc tab that adds the subtotal and tax amounts.  Then on the report side, you can add a label to the header, DBText to print the combined amount for each transaction, and then a DBCalc that does a sum of the new field at the bottom.
The other option is to add a label to the header, a variable in the detail section that adds the SubTotal and the Tax amounts from the table, and then another variable in the footer that adds the values from the TotalSubtotal and the DBCalc8 (which prints the total tax) DBCalc fields.

Reply to Thread