Queries are powerful tools for data analysis within Business Central, allowing us to perform a range of calculations that help us aggregate and make sense of our data. To do this, we set a Method property on a chosen column within our query, which gives us a clear way to “manipulate” the data.

Among the built-in methods we have, there are several that work with numerical datatypes – like Decimal, Integer, Big Integer, or Duration – such as Sum, Average, Min, Max, and Count. There are even a few methods available to help us work with Dates in Business Central. This blog post will hopefully be a good demonstration of the different query methods available, and spark some ideas where you could skip expensive looping techniques in favor of leveraging queries. 😺Rogan says “don’t sleep on using Queries in your Business Central Development!”