Share
ReportHi 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
You’re offline. This is a read only version of the page.
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
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?
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (