Better Formula Editor for Anaplan
Item media 6 screenshot
Item video thumbnail
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 5 screenshot
Item media 6 screenshot
Item video thumbnail
Item video thumbnail
Item media 2 screenshot
Item media 3 screenshot
Item media 4 screenshot
Item media 5 screenshot
Item media 6 screenshot

Overview

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

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. 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.

4.6 out of 55 ratings

Google doesn't verify reviews. Learn more about results and reviews.

Review's profile picture

Shubham ChaudharySep 21, 2022

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.

Review's profile picture

Katherine SmithJun 22, 2022

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.

Review's profile picture

Pandji MahardikaJan 26, 2022

Nice working, very usefull

1 out of 2 found this helpful
Replier's profile picture

George DuckettDeveloperJan 26, 2022

That's great to hear, thanks!

Details

  • Version
    3.0.6
  • Updated
    March 14, 2023
  • Offered by
    George Duckett Development
  • Size
    1.36MiB
  • Languages
    English
  • Developer
    Email
    georgeduckettdev@gmail.com
  • Non-trader
    This developer has not identified itself as a trader. For consumers in the European Union, please note that consumer rights do not apply to contracts between you and this developer.

Privacy

The developer has disclosed that it will not collect or use your data.

This developer declares that your data is

  • Not being sold to third parties, outside of the approved use cases
  • Not being used or transferred for purposes that are unrelated to the item's core functionality
  • Not being used or transferred to determine creditworthiness or for lending purposes

Support

Related

Feedbin Notifier

5.0(3)

Provides a basic notification service for the RSS aggregator Feedbin.

Anaplan Formulator

4.2(5)

Compatible with the new model experience - Makes Anaplan formulas easier to read

Sort My Classes

5.0(2)

Sort the classes on schedule builder based on ratings of professors!

Probability Toolkit

5.0(3)

A tool to help quickly calculate different probability values for various distributions.

Bunpro Review Notifier

3.7(3)

Displays the number of reviews on Bunpro

Snap Environment Switcher

5.0(16)

Switch between environments and modes in complex solutions like AEM.

Better OLWLG

0.0(0)

Makes the Online Want List Generator prettier and improves its accessibility.

Improved Anaplan

4.9(15)

Improving Anaplan User & Model Builder Experience and increasing efficiency. Brought to you by valantic.

Tiny Tiny RSS Open in Background Tab

3.7(3)

Open Tiny Tiny RSS links in a background tab using a shortcut key.

Better Anaplan by Atkan

0.0(0)

Enhance Anaplan features

BetterCacher

0.0(0)

The BetterCacher Chrome extension will show you on the geocaching.com page if the cache is listed on BetterCacher.

Glints TalentRadar

0.0(0)

Supercharge your sourcing efforts.

Feedbin Notifier

5.0(3)

Provides a basic notification service for the RSS aggregator Feedbin.

Anaplan Formulator

4.2(5)

Compatible with the new model experience - Makes Anaplan formulas easier to read

Sort My Classes

5.0(2)

Sort the classes on schedule builder based on ratings of professors!

Probability Toolkit

5.0(3)

A tool to help quickly calculate different probability values for various distributions.

Bunpro Review Notifier

3.7(3)

Displays the number of reviews on Bunpro

Snap Environment Switcher

5.0(16)

Switch between environments and modes in complex solutions like AEM.

Better OLWLG

0.0(0)

Makes the Online Want List Generator prettier and improves its accessibility.

Improved Anaplan

4.9(15)

Improving Anaplan User & Model Builder Experience and increasing efficiency. Brought to you by valantic.

Google apps