Better Formula Editor for Anaplan

Better Formula Editor for Anaplan

This extension enhances Anaplan formula editing in several ways; providing code completion, hover info and validity checks.

What is Better Formula Editor for Anaplan?
Better Formula Editor for Anaplan is a Chrome extension designed to enhance Anaplan formula editing, offering autocompletion of code, contextual information when hovering over elements, and formula validity checking. It's compatible with the 'new model experience' and provides formula formatting options. Other features include 'quick fixes' for errors, function information, and standard Monaco editor shortcuts.
Stats
Users: 706 ▼ -4
Rating: 4.60 (5)
Version: 3.0.6 (Last updated: 2023-03-14)
Creation date: 2021-12-24
Risk impact: Low risk impact
Risk likelihood: Low risk likelihood
Manifest version: 3
Host permissions:
  • https://*.app.anaplan.com/*/anaplan/*
  • https://*.app.anaplan.com/a/modeling/*
Size: 1.43M
Stats date:

Other platforms

Not available on Firefox
Better Formula Editor for Anaplan
Better Formula Editor for Anaplan (v3.0.6)
0.00 (0) 144
Want to check extension ranking and stats more quickly for other Chrome extensions? Install Chrome-Stats extension to view Chrome-Stats data as you browse the Chrome Web Store.
Chrome-Stats extension
Summary

Works best with the 'new model experience', but can work with the old/current.

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.

See more
User reviews
I have just started using it. I like the extension. I'll update my experience and suggestions here after some days. Thanks George for the extension.
by Shubham Chaudhary Shubham Chaudhary, 2022-09-21

I really like having the text formatting, but I would like an option to get rid of the hover window. I mostly don't need it and it blocks my screen.
by Katherine Smith Katherine Smith, 2022-06-22

Nice working, very usefull
by Pandji Mahardika Pandji Mahardika, 2022-01-26
View all user reviews
Safety
Risk impact

Better Formula Editor for Anaplan is relatively safe to use as it requires very minimum permissions.

Risk likelihood

Better Formula Editor for Anaplan has earned a fairly good reputation and likely can be trusted.

Upgrade to see risk analysis details
Promo video
Screenshots
Similar extensions

Here are some Chrome extensions that are similar to Better Formula Editor for Anaplan: