Analytical expressions support a varied range of inbuilt functions. These functions can be used for performing complex calculations such as aggregation functions, date and time functions, filter functions, and so on.
Following is the list of analytical functions supported in Wyn Enterprise:
This function helps in calculating a (scalar) value such as count, sum, average, minimum, or maximum for all rows in a column or table as defined by the expression.
This function helps in performing calculations across a set of table rows that are somehow related to the current row.
These functions are very similar to the date and time functions of Microsoft Excel. You can use these functions to extract dates, calculate the difference between two dates, find the current date and time, and much more.
This function helps you to return a specific data type, lookup values in related tables, and filter by related values. The Lookup function works by using the tables and relationships between them. Filtering functions help you to manipulate data context for creating dynamic calculations.
This function returns information about values in an expression. For example, the TRUE function helps you to determine whether an expression that you are evaluating returns a TRUE value.
Mathematical functions are very similar to Excel's mathematical functions, which are used to perform basic math functionality on your data. For example, you can use mathematical functions to find the square root, round, absolute value, and so on.
This function helps you to create calculations that use built-in knowledge about calendars and dates. You can build meaningful comparisons across comparable periods for sales, inventory, etc. by using time and date ranges in combination with aggregations or calculations.
This function returns a table or manipulates existing tables.
This function enables you to return part of a string, search for text within a string, or concatenate string values. Some additional functions help you to control the formats for dates, times, and numbers.