Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Sort by Sum for data sources other than NAV

When working with a data source other than Dynamics NAV (for example, a SQL database), sorting by the Sum of a field is quite simple.

Let's assume the following data is in the DEPT table of our database:

table.png

and we want to list our department numbers, sorted by the decreasing value of the sum of the Amount field.

Our functions would look like this:

sort_functions.png

with the results of:

results.png

Published:

Sort by Sum for data sources other than NAV

When working with a data source other than Dynamics NAV (for example, a SQL database), sorting by the Sum of a field is quite simple.

Let's assume the following data is in the DEPT table of our database:

table.png

and we want to list our department numbers, sorted by the decreasing value of the sum of the Amount field.

Our functions would look like this:

sort_functions.png

with the results of:

results.png

For an optimal Community experience, Please view on Desktop