Find the item with the largest number of entries

(0) Share

Report

Posted on by Community Member

Hi!!! I have a problem with my task. I have 4 entries in my table, and I need to find the most popular ones (those with the same ID), in my case it's an entry with (ID 501 MERCEDES - 3 rec). I need to show a message something like: The most popular record with ID 501. when I start the table. Can You explane how to do it? I`m new in navision development. Thanks!

4186.Untitled.jpg

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Mouli Kaku 517 on at

Like (0)

Report

Hi Serega, create a flow field on item(where you would like to show ) for count with id filter on those entry table . so whenever you open item list it will calculate no of entries on item card, if you like it in sorting order then flowfield won't work.

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (1)

Report

Hello Serega

You have to write your custom logic in any Page Action or Codeunit.

best idea is create a secondary key of field that you want to check, and sort the records.

for reference purpose see below code, its just for reference not your whole solution.

Was this reply helpful? Yes No
Suggested answer

AJAnsari 5,754 on at

Like (0)

Report

Do you HAVE to do it inside NAV? And does the result need to be displayed as a Report? A Page? Tools like Excel/PowerPivot or Power BI will do this in minutes by pivoting and showing the count of records per ID or sum of Total Revenue or Cost of Sales per Item ID.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks! after little modifying your code/logik started to work

Was this reply helpful? Yes No
Binesh 7,885 on at

Like (0)

Report

Hello Serega,

If mentioned solutions helped you then mark answer is verified, so other members will be benefited

Was this reply helpful? Yes No