It’s a kind of Magic: 5 Hyperion Planning Shortcuts that will make your life easier
I am about to share something that Planning users will love: do you know that you can add, subtract, multiply, divide, and add a percentage to the existing value directly in a Planning Webform? Aaron Slack shared with me this very interesting undocumented feature last week.
A simple example:
In the cell, type + and the amount you want to add: in our example, let’s say you want to add $1,000,000 to 40001 – DIRECT SHIP: you will type +1000000
the result is immediately calculated:
Pretty nice, isn’t it?
To Subtract, enter +- and the value you want to subtract:
To multiply, enter * and the value you want to multiply:
To Divide, enter / and the value you want to divide:
To apply a percentage, enter % and the percentage:
This feature in a nutshell:
- This awesome feature won’t work with SmartView (but I don’t think it is really necessary as MS Excel has a lot more mathematical functionalities as you all know).
- I have not been able to apply a negative percentage
This shows 2 things:
- This feature has been around for quite some time and I heard about it for the first time in 2015: we can learn new things every day!
- Sometimes, undocumented features can benefit users