Show TOC

Syntax documentationEvTIM Locate this document in the navigation structure

The EvTIM (time period offset) function specifies an offset from a given time period. A typical use of this function is as follows:

  1. In cell D4 of a new workbook, enter an EvCVW function to return 2008.Q1.

  2. In cells E4 through G4, enter an EvTIM function, with an offset of 1. These cells should retrieve 2008.Q2 through 2008 Q4

  3. When you change the CurrentView to 20028.Q1, all the cells change accordingly, showing 2008.Q2 through 2008.Q3. If you change CurrentView to 2008.JAN, the other cells retrieve 2008.FEB through 2008.AP.

Syntax Syntax

EvTIM(AppName,Member,Offset,Level)

Insert AppName

Member — The member to start from, for example, Budget2008.

Offset — The number of time period increments.

Level — (Optional) Level only supports the value Year.

End of the code.

Note Note

You can use an offset of −1.

End of the note.

Example Example

In the following example, the cell containing the EvTIM formula increments one period based on the value in cell D4. By default, if the optional Level parameter is not included, it increments the period at the same level as the member specified.

For example, if cell D4 contains 2078.Q1, and no level is specified, an increment of 1 returns a value of 2008.Q2, and increment of 2 returns 2008.Q3, and so on. If cell D4 contains 2007.TOTAL, an increment of one returns 2008.TOTAL.

EvTIM(Finance,D4,1)

End of the example.