Active Topics
Active Posts
Unanswered Posts
Search
Advanced
You are not logged in. [
Log In
]
Adagio Home Page
»
Forums
»
General Discussion
»
General Inquiries Forum
» Filter Help
Register User
Forum List
Calendar
Active Topics
Search
FAQ
Topic Options
#20966
-
02/11/10
09:55 AM
Filter Help
George_H
New Guy
Registered: 02/11/10
Posts: 5
Loc: Canada
(74.14.0.251)
New user to Gridview.
I am looking for help with a filter that will allow me to view the top 25 customers by selected amount.
ie. I would like the filter to promt me the dollar amount I want to look at.
Top
#20967
-
02/11/10
10:01 AM
Re: Filter Help
[
Re: George_H
]
Retired_Guy
Adagio Master
Registered: 03/16/99
Posts: 10504
Loc: Canada
(96.49.96.191)
Hello George,
Assuming you like to identify all customer's who's YTD purchases exceed a user entered amount, you'd use the filter:
Code:
{Inv Total - YTD} >= QUERYNUMBER("How large?",10000)
Is this what you're looking for?
_________________________
Andrew Bates
Top
#20968
-
02/11/10
10:06 AM
Re: Filter Help
[
Re: Retired_Guy
]
George_H
New Guy
Registered: 02/11/10
Posts: 5
Loc: Canada
(74.14.0.251)
Perfect, thank you.
Top
Previous Topic
Index
Next Topic
Preview
Hop to:
General Discussion ------
General Inquiries Forum
Technical Support
Moderator:
Softrak Support
Print Topic
Switch to Threaded Mode
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
View profile
Send a PM
Add to your Watched Users
View posts
Who's Online
0 registered (), 106 Guests and 5 Spiders online.
Key:
Admin
,
Global Mod
,
Mod
Forum Stats
1874
Members
5
Forums
14563
Topics
71065
Posts
Max Online: 484 @
10/22/25
07:22 PM
November
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
Board Rules
·
Mark all read
Default Style
Forum-Style
Forum-Style-New
Softrak_Blue
Contact Us
·
Adagio Home Page
·
Top
Previous Topic
Index