I have one table called BAGS with three fields:
- Bag Name
- Monthly Sales
I am trying to display data to a repeating group to show all the bags where:
TotalStock < Monthly Sales
Currently the search function does not let me compare these two fileds.
Also how do I filter results if I want to do:
TotalStock < 2 x Monthly Sales
So to display all the bags whose stock number is smaller than twice their monthly sales?