Topic Options
#36816 - 05/08/13 12:27 PM Gridview OR
LanceBakker Offline
Adagio Enthusiast

Registered: 01/10/13
Posts: 25
Loc: Trenton, Ontario
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

Top
#36819 - 05/08/13 06:36 PM Re: Gridview OR [Re: LanceBakker]
Steve Schwartz Offline
Adagio God

Registered: 03/10/02
Posts: 4512
Loc: Wynnewood, PA
Hi Lance

The "OR" brackets are wrong. I also cleaned up the formatting a bit.

AND(
{Stock Item?} = 1
,
TRIM({Report Group})<>"CLR"
,
TRIM({Report Group})<>"SPO"
,
OR(
{Sugg Order YTD} > 0
,
{Sugg Order LY} > 0
)
,
OR(
Left({Vendor 1 Code},6) =Left(QueryString("Enter Vendor Number"),6)
,
Left({Vendor 2 Code},6) =Left(QueryString("Enter Vendor Number"),6)
)
)

Top
#36821 - 05/09/13 09:06 AM Re: Gridview OR [Re: Steve Schwartz]
LanceBakker Offline
Adagio Enthusiast

Registered: 01/10/13
Posts: 25
Loc: Trenton, Ontario
Thanks, this worked perfect.
_________________________
Lance Tennier
TDL Canada

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 56 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14474 Topics
70689 Posts

Max Online: 432 @ 01/20/25 10:17 PM
May
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31