Allow OFFSET calculation in version formula
Allow OFFSET to be used on summary line item formatted as Formula.
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.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!