Training
Module
Analyze list data using data analysis mode in Business Central - Training
Learn how to analyze list data by using data analysis mode in Dynamics 365 Business Central.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
List.Mode(list as list, optional equationCriteria as any) as any
Returns the item that appears most frequently in list
. If the list is empty an exception is thrown. If multiple items appear with the same maximum frequency, the last one is chosen. An optional comparison criteria value, equationCriteria
, can be specified to control equality testing.
Find the item that appears most frequently in the list {"A", 1, 2, 3, 3, 4, 5}
.
Usage
List.Mode({"A", 1, 2, 3, 3, 4, 5})
Output
3
Find the item that appears most frequently in the list {"A", 1, 2, 3, 3, 4, 5, 5}
.
Usage
List.Mode({"A", 1, 2, 3, 3, 4, 5, 5})
Output
5
Training
Module
Analyze list data using data analysis mode in Business Central - Training
Learn how to analyze list data by using data analysis mode in Dynamics 365 Business Central.