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!
There are couple of ways, you can use the query as discussed in the below blog
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?
Business Applications communities