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.PeriodNumber
Return 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 |