Financial Report Column Definition - TOTAL of prior 12 months formula

(0) Share

Report

Posted on by AM MCA

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]