This extension enhances Anaplan formula editing in several ways; providing code completion, hover info and validity checks.
Better Formula Editor for Anaplan Extension
Formula Validation: Various checks are performed on formulas including simple things like ensuring all entities are named / referenced correctly or ensuring the correct data types are used throughout the formula, through to things like checking for dimension miss-matches when referring to line items with different dimensions.
Formula Formatting: Provides basic formatting for valid formulas; breaking up IF...THEN....ELSE onto multiple lines with proper indentation.
Hover Information: You can hover your mouse over most elements of a formula to get contextual information, for example hovering over line items shows their dimensions and data type and hovering over function names to get information about that function.
Code Completion: As you are typing the editor will offer auto-complete suggestions for things like line items within the current module, fully qualified line items within other modules, function names etc. As well as that, where you reference a line item with differing dimensions to the current modules dimensions it can auto-complete the required LOOKUPs or SUMs needed based on what you've used elsewhere.
Quick Fixes: When errors are encountered the extension will allow the user to choose an appropriate fix from a menu which when chosen would make the required changes to the formula automatically.
Function Information: When completing functions with parentheses you get popup contextual information relating to the parameters of the function together with an explanation of both the function and the parameters. You also get parameter type checking, and if the given parameter expects a keyword, these get auto-completed.
Shortcuts: Standard Monaco editor shortcuts apply. Ctrl-Space; Open code completion. Ctrl-Shift-Space; Open function info (when within function parentheses). Shift-Alt-F for formatting.
I welcome ideas for future enhancements; this is very much in active development. If you would like to sponsor me, you can do so here: https://github.com/sponsors/georgeduckett There are various tiers available with a variation of benefits.
Source Manifest.json
Similar Extensions
Bunpro Review Notifier 625 3 ★ 31.87KiB
Live Reload Browser Page (Pro) 625 1 ★ 3.83MiB
Improved Anaplan 625 16 ★ 60.37KiB
Elon Be Gone 625 2 ★ 252KiB
Better Anaplan by Atkan 625 0 ★ 5.63KiB
BetterCacher 625 0 ★ 60.67KiB
Glints TalentRadar 625 0 ★ 105KiB
Anaplan Formulator 625 5 ★ 72.64KiB
Probability Toolkit 625 4 ★ 63.07KiB
CSS Injector 625 0 ★ 2.85MiB
Safer Send Button 625 0 ★ 99.29KiB
Feedly Star Opener 625 3 ★ 52.94KiB
DemoMonkey 625 7 ★ 1.36MiB
Traction Guest 625 1 ★ 60.52KiB
Reddit FRANK Detector 625 2 ★ 48.7KiB
Anti FeR toolkit 625 3 ★ 85.54KiB
CSS Brio Pro 625 3 ★ 308KiB
Better OLWLG 625 0 ★ 272KiB
Feedbin Notifier 625 3 ★ 16.44KiB
Tiny Tiny RSS Open in Background Tab 625 4 ★ 30.81KiB
Sort My Classes 625 2 ★ 910KiB
Snap Environment Switcher 625 16 ★ 208KiB
Polygonscan Quick 625 0 ★ 12.28KiB
WCL Ranked Buff Remover 625 3 ★ 1.15MiB
User reviews
Shubham Chaudhary (ID: 0000006f31d6cc50) Voted 4 ★ - Updated 09/21/2022
Pandji Mahardika (ID: 000000b607bd6b99) Voted 5 ★ - Updated 01/26/2022