 Getting Started
 Administration Guide

User Guide
 An Introduction to Wyn Enterprise
 Document Portal for End Users
 Data Governance and Modeling
 Working with Resources
 Working with Reports
 Working with Dashboards
 View and Manage Documents
 Understanding Wyn Analytical Expressions
 Section 508 Compliance
 Subscribe to RSS Feed for Wyn Builds Site
 Developer Guide
Functions
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:
Aggregation Functions
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.
Windows Functions
This function helps in performing calculations across a set of table rows that are somehow related to the current row.
Date and Time Functions
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.
Filter Functions
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.
Logical Functions
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.
Math Functions
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.
Time Intelligence Functions
This function helps you to create calculations that use builtin 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.
Table Manipulation Functions
This function returns a table or manipulates existing tables.
Text functions
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.