You’re offline. This is a read only version of the page.
25
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.
#1
André Arnaud de Cal...
291,188
Super User 2024 Season 2
#2
Martin Dráb
230,030
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (