6 years (broken down into months) and yes, a new year will be added every year (but not frequently obviously). I'm currently summing up the 6 FY totals manually in the formula and doing a check on this but it's a bit clunky as the formula will need to be edited manually each year the model is rolled over (admittedly not a big job if it's documented properly). Although I'm hoping there's some sort of 'NOT CURRENT PERIOD' type formula that'll do it a bit neater, in the absence of the all periods field in this model.
... View more