Home > OLAP Calculation Templates > Prior and Future Periods > Difference from Future Period
![]() Previous |
![]() Next |
Returns the difference between the current value and a value of a later time period at the same level.
Difference from future period for measure (...) in the time dimension and time hierarchy hierarchy number period ahead.
This calculated measure returns the difference in Units between the current time period and the next time period.
Difference from future period for UNITS(...) in the TIME dimension and TIME.CALENDAR hierarchy 1 period ahead.
The Change column shows the difference between the current time period and the next time period. A Future Period calculation computes the values in the Next Period column.
Time Level Units Next Period Change ------ -------------------- ------- ----------- ------ Q1.04 CALENDAR_QUARTER 146529 143070 3459 Q2.04 CALENDAR_QUARTER 143070 148292 -5222 Q3.04 CALENDAR_QUARTER 148292 149528 -1236 Q4.04 CALENDAR_QUARTER 149528 143607 5921 Q1.05 CALENDAR_QUARTER 143607 138096 5511 Q2.05 CALENDAR_QUARTER 138096 138953 -857 Q3.05 CALENDAR_QUARTER 138953 145062 -6109 Q4.05 CALENDAR_QUARTER 145062 146819 -1757 2004 TOTAL 587419 565718 21701 2005 TOTAL 565718 584929- 19211