Hi,
Refer attached cashflow. I'm looking to evenly amortise the values of C4 & D4 within the 'Assumptions' sheet over the financial year (FY14 / FY15) within the cashflow sheet. For example cell B4 in the 'cashflow' contains commited contracts and I would like to add a forecast, which is the value in C4 & D4 within the 'Assumptions' sheet.
Any help would be greatly appreciated.
PERE
See attached. I'm guessing this is what you are looking for.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
almost, I just need it to reference the FY14 part. is it a countif? so if FY14 is reduced to say 8 months, then the value is divided proportionally.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks