August 2023: Dynamically Aggregate Array Values, Validation Update and Fixes

New

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.