Functions that Typecast Within Relative Time Period References
These functions convert time levels. The conversion occurs before other operations in the formula:
Definition
Converts to a week.
Returns
A week
Example
v350.0.001 (-2(@week))
Definition
Converts to a month.
Returns
A month
Example
-v350.0.21 (+2q(@month)) - @input
Definition
Converts to a quarter.
Returns
A quarter
Example
v350.000.05(-4y(@qtr))
Definition
Converts to a half of a year.
Returns
Half of a year
Example
v350.0.001 (-3(@half))
Definition
Converts to a year.
Returns
A year.
Example
v350.0.18(-18m(@year))