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