What's New In Financial Edge NXT: Calculations For Table Insights

Ellyn Hassell

In Analysis, Insights, you can design tables to view

measures and attributes as rows and columns, like a spreadsheet. When you design a table with at least one measure and attribute, you can now apply a calculations — such as sum, average, or median — to a column's values. To calculate a column, hover over the column, select ∑, and choose the calcuation to apply.

• To apply the same calculation to multiple columns, hover over the calculation's row under the column, and select Add (the plus sign).
• To apply the same calculation as the column's measure to the overall measure instead of the column's values, select ∑, Rollup (total). For example, with a column of averages, Rollup (total) provides the average of the overall measure, not the average of the column's averages.
• To remove a calculation from a single column, select its X. To remove a calculation from all columns, select the row's X.

For more information, see the Insights Help and Measures and Counts Help.