AnsweredAssumed Answered

SQL that lists Annual Forecasted Costs for 2015 & 2016 by Investment

Question asked by ben.jones on Sep 11, 2014
Latest reply on Sep 12, 2014 by ben.jones

I made a start at writing some sql for this before quickly realising I'm horribly out of my depth.  Does anyone have some sql for this already in place?


I need to list each investment id & name, followed by their forecasted cost for 2015/16 broken down by cost type - as annual figures.


Does anyone have somethink like this already?  This table displays our time periods i think: NBI_DIM_FISCAL_TIME