I've set up a report using the table builder to send me daily any prices entered onto sales orders yesterday which are below the required profit margin. I'm using sales lines and then an ideal cost field from the item table.
I have added in a formula using to calculate the margin, I'm half way there in that the report is working, but I want to filter on these calculated values so I only get the prices that are too low rather than every sales line for the day.
Is there a way to do this? Please explain for a beginner as I've only been using for a few months and this is probably the most complex thing I've attempted!
Thank you in advance