Hi All
having completed the 102 course I am in the process of building my first model, so please be gentle if I have asked a ridiculious question but I really cant figure this out.
I have a line item showing balances across time periods and I would like a second line that shows the average for the financial year for the same time periods, I feel like this should be really easy but having read through parts of Anapedia and the forum I feel like I'm getting nowhere.
I believe it is something to do with timesum but I have yet to figure out how to identify the start and end periods for a financial year to feed into that calculation.
Please help!
Stewart