The following list describes the time frame calculations that the CalcBuilder supports.
Moving Average -- Averages values for a moving number of time periods.
Example: Average Sales for the previous 6 months.
Moving Maximum -- Calculates the maximum value for a moving number of time periods.
Example: Calculate the maximum value of Sales for the previous 6 months.
Moving Minimum -- Calculates the minimum value for a moving number of time periods.
Example: Calculate the minimum value of Sales for the previous 6 months.
Moving Total -- Totals values for a moving number of time periods.
Example: Total Sales for the previous 6 months.
Year to Date -- Totals values from the beginning of the calendar year to the current time period.
Example: Total Sales from the January to the current time period.
Basic Arithmetic Calculations
Advanced Arithmetic Calculations
Prior/future Comparison Calculations