(Showing Draft Content)


This article provides some of the limitations of Wyn Analytical Expressions. Listed below are the details:

  • Does not support the Values function as a modifier function to restore a special column as a dimension in the Calculate function.

  • While using the calculate function in a nested scenario, each filter expression in each Calculate function will perform a logic conjunction.

  • Does not support aggregation functions in a Calculated Column.

  • Some databases do not support Boolean-type columns using Min or Max aggregation function. Example: SQL server.

  • CONCATENATEX or CONCATENATE function only support the special version or later.

    Example: For the SQL server, the version needs to be greater than version 13.

  • Does not support any window functions if the first parameter is not null/ empty string in a calculated column.