Hello Fullen,

No, you do not need the second FPERIOD() call.

The formula should be:


This formula subtracts the ending date for the current period last year (because you are using "P" before the period number - for the current year you'd use "C") from the starting date of last year's fiscal year.

(Presumably you have 99 rooms available each day, and E24 contains your total room revenue).

No, you do not need the 2nd FPERIOD().

FPERIOD() returns the number of the Fiscal Period that you have selected (i.e. 1 through 12).

Andrew uses the first FPERIOD() to create the parameter to the function ADGET(). For instance, in period 12 you need "P12". It varies depending on the Period you choose.

But in the 2nd ADGET(), you already know that you want "P 1". It will never change. Therefore FPERIOD() is not needed.