Allow OFFSET calculation in version formula

Description:

Allow OFFSET to be used on summary line item formatted as Formula.

Impact/Benefit:
I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For example, year-over-year % changes using a formula at the aggregated level: Total Growth in Net Sales / OFFSET(Net Sales, -1, 0).
A previous resolution provided was to put the OFFSET function on a different line, and make a reference line item a Formula summary. However this would substantially increase the amount of line items that I would need as I would need to have two lines for every single growth metric.

Comments

AnaplanIdeas

Status changed to: On Roadmap

rhernandez

I am agree, we have modules that can have bilions of cells and add a new line item to calculate just the Year over Year growth can decrease the availability of space, i think that have formula combined with offset in the summary method could be very helpfull

Quick Links

New ideas

Anaplan Color Pallet
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: The Anaplan Color pallet should be consistent across all forms. Text Pallet is different Action Icon Default Colors, and different…
Workflow: Continue Workflow after Decision Task Rejection
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: Currently a workflow ends if a decision task is rejected and it is not possible to add workflow steps after the rejection. I want to…
Allow non-WSAs to view source module name in UX.
When a user clicks the ellipsis in a grid card they should be able to see the name of the source module. This empowers end users with the ability to connect to the source data they see in the UX to the module in the backend. It also enables end users to pull the data into Google Sheets or Excel.