On a planning sheet, when an amount is entered in the FY TOTAL cell, how does the option to "break back proportionally using prior year" work?
What is the basis used for "prior year?" Actuals? Prior year Plan?
The break back is based on the information displayed. If you are on a sheet that is displaying Actuals, then it will use the prior year's Actuals. If the sheet is displaying plan numbers, then it will use the plans prior year numbers.