Hi everyone,
I'm having trouble with some report calculations. I think it may be something to do with thr group settings but can't be sure.
Basically I have a cash flow projection report and i want to include a brought forward, movement and carried forward calculation at the bottom of each month.
The report is grouped by financial year so the calcs should show up on 2012/13 and at the bottom of 2013/14. Ideally i want there to be a running total from june 2013 (Balance carried forward at year end) to be the balance carried forward at the beginning of the following financial year.
I have started this but can't figure out how to link the years together. Also the report will only display balance b/f and c/f for 2013/14 and not 2012/13 and i can't figure out why?
Can someone take a look for me and see what's going wrong?
Thanks in advance
Tom