Hello, I am filtering multiple items from the inventory report with {REPORT CONSUMPTION DETAILS}. So far added one condition but want to add another condition on the items I can see in the report.
I am having trouble using multiple AND conditions in a report. I need help making a commission report with commission awarded to the waiter based on the price of the item sold. for example for a drink with a price from 100,000 to 150,000 commission is 10,000. From 150,001 to 200,000 commission 15,000… and so on… I have tried with the code below but its not working. Is there code for Between like in SQL?
@{REPORT ORDER DETAILS:O.User.asc:(ODI=True):{0}:,}
[Item Sales by $1:3,2,2]
{REPORT ORDER DETAILS:O.MenuItemName,O.Quantity.sum,[O.Quantity.sum]*10000:(ODI=True) and (OU=$1) AND (O.Price > 100000) AND (O.Price < 150001)}