We've made further improvements to the STRICT / SEMISTRICT mode in LEAD and LAG functions. Previously, LEAD and LAG accepted the optional mode argument, ignored the given offset, and used the fill value. However, the calculation was not restricted to refer to only specific periods in SEMISTRICT / STRICT mode, which would avoid a circularity error in a self-referencing formula.
SEMISTRICT LEAD now references the current period and future periods
STRICT LEAD now references the future periods
SEMISTRICT LAG now references the current period and past periods
STRICT LAG now references the past periods
This allows a formula such as target = LAG(target, offset, fill, STRICT), where offset > 0, and avoids any circularity exceptions.
Text-link formatted Line Item disables hyperlink if '#' character is present
Previously, any hyperlink that included the '#' symbol did not register as a clickable URL. (This was a particular issue for users of Salesforce Chatter and Google Sheets, which frequently use the # symbol in URLs.) Now, hyperlinks that include the # symbol that are pasted into an Anaplan line item are recognized as clickable URLs.
Fixes and Known Issues
The following issues related to synchronizing model changes are resolved in this release:
If you remove a list or line item subset from a module's default dimensions and then delete the list or line item subset, the next sync will fail.
If you remove a list subset from a module's default dimensions and then add a LOOKUP formula to any line item, the next sync will fail. A similar issue occurs with several other formulas.
Known Issues and Workarounds
Known issues and workarounds have been identified for ALM and other general platform items in this release.