Filter reports based on results.
I am using the inventory template in FileMaker Pro 10. I created a report to list out all the items and their counts and reorder level. I want to filter the results to only show what items need to be reordered.
I tried to use this in the script If [Inventory::Amount_In_Stock < Inventory::Reorder_Level] but I know I am not doing it correctly. How do I tell the report to show only the ones below the reorder level.