Looking for a single cell formula for a G/L account(s) total of last twelve month end balances without creating 12 separate G/L function formulas for each month end summed together. Basically looking to use in a yield formula for trailing twelve month yield on various loan product earnings. Need this to be a Jet Reports solution, not Jet Analytics or other offering.

Any assistance would be appreciated.

Thank you.