Returns cumulative sums across a year time span from a single numeric parameter as source then resets.

    Syntax

    YEARTODATE(x)

    where:

    • x: Line item holding the value to cumulate.

    Format

    Input Format Output Format

    x: Number

    Matches the data format used by argument x

    Arguments

    The function uses the following arguments:

    • x: Number: Numeric line item, property, or expression.

    Constraints

    The function has the following constraints:

    • Time Scale of source must be Day, Week, Month, Quarter, or Half-Year.
    • Cannot be used if model Calendar Type is Weeks: General.

    Excel equivalent

    • No Excel equivalent

    Back to Top

    Example

    YEARTODATE is used to show cumulative sales figures for each year period for FY12 through FY16.

    YEARTODATE(Sales)        

    Back to Top

    Similar functions