We are working on a gridview to do ordering. We want it to do a few things.
1. Show only stock items
2. Remove any that have report group CLR (clearance) or SPO (special Order)
3. Only show items that have Suggested order in LY or YTD greater than 0 (These columns were previously figured out by Susan)
4. Only show the items that have Vendor code 1 or 2 that is entered in the query.
I have played around with the following formula and cannot get it to work. This is the best I have come up with. I cannot get steps 3 and 4 to work together. The formula below shows all vendors. How can I fix this?
AND(
1. {Stock Item?} = 1,
2. TRIM({Report Group})<>"CLR",
TRIM({Report Group})<>"SPO",
OR(
3. {Sugg Order YTD}>0,
{Sugg Order LY} >0,
4. Left({Vendor 1 Code},6) =Left(QueryString("Enter Vendor Number"),6),
Left({Vendor 2 Code},6) =Left(QueryString("Enter Vendor Number"),6)
))
_________________________
Lance Tennier
TDL Canada