Gets the period number in the view for the data that is being retrieved. This function can be used in Dynamic SUB functions.
HS.View.PeriodNumber
One value for the number of periods of the view.
Hs.Dynamic "A#MarginPct=A#GrossMargin/HS.View.PeriodNumber"
| 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 |