How to add prior year data value

MadhabikaM
MadhabikaM
in Modeling

Hi,

 

I have a line item Headcount and my current year is FY17.

 

For FY18 I need headcount value to be prior year headcount and FY19 to be FY18+FY17 headcount value.

 

Can I please get some guidance.

 

Regards

Madhu

Tagged:

Answers

  • ben_speight
    ben_speight

    You'll need two line items - one to enter/hold the headcount change, and one with a formula to maintain a running balance over time - use the PREVIOUS function to access the last value and add the change. You might also want to look into opening/closing balances.

Categories