New Formula Option: Dynamically Aggregate Array Values
The formula editor now has an option to take the sum, product, minimum, maximum or average across all array values. Similar to using a SUMIF or other conditional formulas in Excel, this new operand allows for conditional operations or manipulations across the array values.
The Dynamic (Array) Aggregation Options are found under the Math Functions (Calculator Icon) > Aggregate Calculation (Sigma Icon) option in the formula wheel.
In this example, we are doing a dynamic summation across a data table array.
Change
Changed Validation Error to Warning
Users will now be warned when an Investment Strategy Portfolio variable references a product aggregate with ‘After Investment’ timing set. This is to inform users of potential misconfigurations.
Fixes
Merge mapping logic has been updated to better handle name changes.
Updated the Debug View to show all fields for Present Value and Goal Seek formulas.
User will no longer get an unknown error when merging a variable that does not have an array set in the variable properties of the source model and does have an array set in the variable properties of the target model.
Resolved a temporary issue resulting in unknown errors on the run logs.
Merge Multiple Table Structures and Data Tables at Once
The Governance module now allows users to merge multiple table structures and data tables at once so that each data table and table structure does not have to be individually merged one at a time. All nested table structures included in the mass merge will be automatically mapped for a more efficient merge experience.
Select Table Structures on the left panel, check the checkbox for desired structures and tables, and click the ‘Merge # Changes’ button to mass merge table structures and tables.
In addition to the mass merge capabilities, the merge module now refreshes the items in the left hand panel upon merging to remove the changes that no longer exist between the two models.
In-App Resource Center
The new Resource Center provides integrated support article searching and highlights new features within the Slope Application. Walk throughs and additional onboarding content will be available in the Resource Center in the future.
Enhancements
Copy and Paste Workbook Elements and Worksheets
Workbook elements (tables, visualizations, etc) can no be copied and pasted for easy repurposing and editing. You can also copy and paste worksheets.
Delete Workbook Folders
Folders can now be deleted from My Documents or your account’s workspace from within the Workbooks module.
Export All Elements in a Workbook to Excel
You can now export all elements (tables, visualizations, etc) to a single excel file with the ‘Send Now’ functionality. Each element will be sent in a different worksheet of the same excel file.
Fixes
Pasting a part of a formula in the editor will no longer clear out the operator.
Consistently showing the correct variable name in the error message when an aggregate calculation has an empty value.
Resolved an issue in which a renamed variable was listed multiple times when merging model changes in the Governance module.
Corrected the headers on the grouped projections view in the Projections module.
The state of the ‘is required’ property can now be merged in the Governance module.
Users can now merge model point field change if the alias on target model matches a name change.
Validation has been added to workflows to notify users that workflows have a limit of running 40 projections at once.
Large scenario tables should no longer cause projection delays.
