I have a quick question - I want to create a custom report which will display the total sales from the prior month (only for product categories food and drink, no others) and then apply the following math operators to it:
Divide by two
Remove $1000
This is for a local specialty tax calculation. My goal is for the report to display the final number my staff needs to handle paying this. I’ve discovered how to make a report with last months sales but not limit categories nor apply math operations. Can anybody help?