Unable to used new timelines???

4.47K viewsFormulas and Functions

7. YTD = sum(MTD:Month[FIRST]:Year[THIS] .. MTD:Month[THIS]:Year[THIS]) SKIP Beginning Cash,Change in Cash,Ending Cash


I use the time lines in reporting and forecasting. Three statements are generated, and income statement, balance sheet, and cash flow. I import data in to cubes from oracle. The item dimension has MTD imported and YTD is calculated.

Recursive time is used for this calculation (month[first] .. month[this]) This technique works within a matrix (ie income statement). The cash flow uses data from different matrices (mostly balance sheet). [First] aggregates from the beginning of time not within a year.

You are viewing 1 out of 3 answers, click here to view all answers.

Latest Questions