Moving Sum for Formula driven number format line items

SamuelWood

I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a formula.

All suggestions welcome.

Thanks

devrathahuja

Hi @SamuelWood ,
It works on all the line items. What error are you getting?

An example here, C = A+B and moving sum works fine.