SmartList Analyzer adds to SmartList the ability to perform calculations and analytical functions on the columns of data in the SmartList window.
Available functions are:
- Sum – adds all numbers in a column
- Average – add all numbers in a column and divides by the number of records
- Mode – finds the most frequently occurring value
- Standard Deviation – calculates the statistical amount of variance in the numbers in a column
- Frequency – calculates the frequency with which each value appears in the column.
The Mode and Frequency functions work on all types of data, whereas the Sum, Average, and Standard Deviation functions work only with numeric data.
SmartList Analyzer can also add Calculated Columns to any existing SmartList Favorite.
Navigation: Tools >> Setup >> Company >> Setup GP PowerPack
Mark the box next to MODULE: SmartList Analyzer, then click DONE.
The feature will be enabled for the current user. Other users must restart their Dynamics GP client to enable this feature.
Navigation: Open SmartList, then select Extras >> Additional >> SmartList Analyzer
SmartList Analyzer shows the currently selected SmartList Favorite across the top of the window.
The first list shows all of the columns in the Favorite. Select a Column from the Columns list by clicking on it. The selected column is indicated with a blue dot.
Select an Operation from the Operations list. The Operation selection is indicated with a blue dot, and the calculation begins immediately.
To change the selection, click on another Operation or Column. The current calculation, if running, will stop automatically and the new calculation will begin.
The Results window will display the result.
Calculated Columns can be added to any SmartList Favorite. Click the Calculated Columns button.
The Calculated Columns window is used to build the formula for the calculated column.
Enter a Column Name for the new column.
A calculated column must be built from at least one Column or Fixed Value.
To add a column, either (1) double-click on the column name, or (2) select it and click the Add Column button as shown above.
Add an Operation by clicking one of the Operator buttons.
To add a Fixed Value, enter the desired numeric value in the Fixed Value field, then click the Add Fixed Value button.
Remove elements from the formula by selecting it, then clicking the Remove button (the Arrow pointing Left).
Finish the formula by adding additional columns and operators, then click the Add Column button. The column will be added to the right-hand side of the SmartList.
The progress bar on the bottom right hand corner of the window will display progress as the column is added and the formula is calculated.