Math Operations to Custom Report

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?

Good news - This should be easy to achieve using “Field Calculations”…

For more info, take a look here…

1 Like