PeriodNumber
Gets the period number in the view for the data that is being retrieved. This function can be used in Dynamic SUB functions.
Syntax
HS.View.PeriodNumberReturn Value
One value for the number of periods of the view.
Example
Hs.Dynamic "A#MarginPct=A#GrossMargin/HS.View.PeriodNumber"| Period | Periodic | YTD | QTD | HYTD |
|---|---|---|---|---|
| Jan. | 1 | 1 | 1 | 1 |
| Feb. | 1 | 2 | 2 | 2 |
| Mar. | 1 | 3 | 3 | 3 |
| Q1 | 1 | 1 | 1 | 1 |
| Apr. | 1 | 4 | 1 | 4 |
| May | 1 | 5 | 2 | 5 |
| June | 1 | 6 | 3 | 6 |
| Q2 | 1 | 2 | 1 | 2 |
| HY1 | 1 | 1 | 1 | 1 |
| July | 1 | 7 | 1 | 1 |
| Aug. | 1 | 8 | 2 | 2 |
| Sept. | 1 | 9 | 3 | 3 |
| Q3 | 1 | 3 | 1 | 1 |
| Oct. | 1 | 10 | 1 | 4 |
| Nov. | 1 | 11 | 2 | 5 |
| Dec. | 1 | 12 | 3 | 6 |
| Q4 | 1 | 4 | 1 | 2 |
| HY2 | 1 | 2 | 2 | 1 |
| Year | 1 | 1 | 1 | 1 |