SBX - Search With Button

SBX - Forum Post Title

Count Distinct In Nav

Microsoft Dynamics NAV Forum

sindi.drala asked a question on 15 Mar 2019 5:53 AM

Question Status

Suggested Answer

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!

Reply
Suresh Kulla responded on 16 Mar 2019 3:44 PM
Suggested Answer

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.

Reply
sindi.drala responded on 18 Mar 2019 4:43 AM

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?

Reply
Suresh Kulla responded on 16 Mar 2019 3:44 PM
Suggested Answer

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.

Reply

SBX - Two Col Forum

SBX - Migrated JS