Report Design: How to add Total Quantity (Total Quantity + Total FOC Quantity) in the report footer

From AutoCount Resource Center
Jump to navigation Jump to search

Question : I wish to add Total Quantity which is (Total Quantity + Total FOC Quantity) in the report footer. How can I add it?


Answer :

Use Calculated Field.


1) Right click on Invoice Detail and select Add calculation field.

Total qty1.png


2) Right click on the calculatedField1 and select Edit Expression.

Total qty2.png


3) Key in [Quantity] + [FOCQty] in the Expression Editor and click on OK.

Total qty3.png


4) Drag the calculatedField1 to the footer.

Total qty4.png


5) Click on the small arrow above the newly added label to prompt the label task box. Click on Summary.

Total qty5.png


6) At Summary function, select Sum and under Summary Running, select Report. Then click on OK.

Total qty6.png


7) Save the report to new report name and preview it. The Total Qty is showed at report footer.

Total qty7.png


By : Cheryl 190301, Lay Swan 190312, P190319



Go to menu

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS
Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations