@avg(vXXXX, -t)

Definition

Averages a value over “t” periods

The “t” variable can be a month, quarter, or half year. Strategic Finance calculates values for periods with insufficient detail.

Returns

Returns a rolling average of an account for the precious “t” periods.

Example

@avg(v1040, -3q) 

Where Cost of Goods Sold (v1040) is:

v1040

1998

1999

1Q00

2Q00

3Q00

4Q00

Cost of Goods Sold

15

20

4

5

6

7

The calculation in 2Q00:

[5+ 4+ (20*(# of days in 4Q99)/(# of days in 1999)]/3

The result: 5.68

The calculation in 3Q00:

(4+ 5+ 6)/3 or 5.