YEARTODATE cumulates values from a single numeric parameter, within a yearly time range. YEARTODATE resets at each yearly start date, based on Calendar Type.
You could use YEARTODATE to compare sales from the same period of another year.
|Line item to|
|Number||The line item to cumulate in a yearly timeframe.|
The YEARTODATE function returns a number.
- The Time Scale of source must be Day, Week, Month, Quarter, or Half-Year.
- This function cannot be used if model Calendar Type is Weeks: General.
In Polaris, you can use the YEARTODATE function with line items with a time scale of Year. In the Classic Engine, you cannot.
In Polaris, you cannot use YEARTODATE in formulas of line items with a formula summary method. In the Classic Engine, you can.
The example below shows YEARTODATE applied to sales, in half year increments.
|H1 FY20||H2 FY20||H1 |