Hello
I am wanting to use a formula to consolidate the prior 12 months (can be over two fiscal years; ie: April 2022 to March 2023) into a single column but can't figure out a formula. I already know how to use the column formulas for each individual month, but I want to keep my columns less busy with a single consolidated column. The 32 character limit means I cannot do a single formula with [-11M]+[-10M]...+CM or -11M|-10M|...|CM
Is there a single formula to get this done?
I've tried these but they give errors:
Comparison Date Formula: CM-11M..CM
Comparison Period Formula: -1FY[CP]..FY[CP]
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,188 Super User 2024 Season 2
Martin Dráb 230,030 Most Valuable Professional
nmaenpaa 101,156