Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 267 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 384 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
how do i retrieve a value with the most count?
rocf
Member Posts: 4
Hi all,
I am new and I am desperate!
I have a range of dates in a field in a table, and I need to retrieve the value with the highest number of counts, how do I do that in C/AL? Getrangemax will only give me the highest value....
TIA!
rocf
I am new and I am desperate!
I have a range of dates in a field in a table, and I need to retrieve the value with the highest number of counts, how do I do that in C/AL? Getrangemax will only give me the highest value....
TIA!
rocf
0
Comments
GETRANGEMAX will give you the upper end of the range for a record. The following code will give you the count for that range.
If you repeat this in loop, with some additional logic you will get the widest range of all
Regards,
Jyotsna