Announcements
No record found.
Hi guys !How can i count distinct in Nav. Concrete example : Count different values of Job No. in Table 169 Job Ledger Entries.Thank you in advance!
*This post is locked for comments
There are couple of ways, you can use the query as discussed in the below blog
blogs.msdn.microsoft.com/.../application-design-pattern-select-distinct-with-queries
or you need to loop the job ledger entry table and insert into the Job Table by making it Temporary variable and insert into the table only if it does not exist then take the count of it.
Thank you so much for your response.Actually i need to count in total this different values .How can i apply this on the querry over the count variable?
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
