--- schema_version: "1" id: 321537ead6425fac6567d7aa2113138b953c7800c5108d999f91a9264e624801 title: Accumulated Variables in Accelerator Functions collection: admin version: current locale: en-us portal_url: https://docs.salesforce.com/admin/current/en-us/sales/264-0-0/spiff_accelerator_accumulated_variable.md canonical_url: https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_accumulated_variable.htm&release=264.0.0&type=5 source_site: help.salesforce.com content_type: documentation content_hash: 742359eb95cd4deec964a061a7fed1d729d9482b22b645bc10e3fdecee4d0a33 description: An accumulated variable is often used with the initial_value argument in the mamount() and mpercent() accelerator functions in Salesforce Spiff. products: - Sales Cloud - Sales Enablement release: "264" --- # Accumulated Variables in Accelerator Functions An accumulated variable is often used with the initial\_value argument in the `mamount()` and `mpercent()` accelerator functions in Salesforce Spiff. ### Required Editions
Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
Available in: Enterprise, Unlimited, and Developer Editions
Available for an additional cost in: Professional Edition with Web Services API Enabled
In this example, retired quota determines commission rates. A rep receives a 4% commission for the first $150,000 of ARR closed. That same rep receives an 8% commission rate for the next $100,000 of ARR closed, but the 8% rate doesn’t apply to the initial $150,000 earned. The rep has already closed $145,000 in ARR and then closes a new $20,000 deal. The $145,000 of previously closed ARR is the initial\_value for the `mamount()` or `mpercent()` function. Based on the range table, the first $5,000 of the new ARR is allocated to Tier 1 and the remaining $15,000 in ARR is allocated to Tier 2. The initial\_value of $145,000 represents an accumulated variable, or the accumulation of ARR for the designated time period. If you measure quotas or performance quarterly or yearly, but statements are monthly, accumulated variables can help you track deals for a longer time period than your statement. For example, a monthly statement shows deals closed only in the month by using a data filter such as ClosedByRepInPeriod. If the accumulation occurs quarterly, set the accumulation filter on the accumulated variable to ClosedByRepInQuarter. Only deals in the current month are visible, but the accumulation includes the entire quarter. ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-sales-sales_performance_management-264-0-0-production-enus/b1f2feb4-26b8-444f-97f7-be2349869d93/images/icon_note.png) Note A quarterly statement period using a ClosedByRepInQuarter data filter can’t have an accumulated variable with a shorter duration than the given period. A ClosedInMonth accumulation filter on a quarterly statement period causes deals in the quarter that are outside the ClosedInMonth filter to show an error. #### See Also - [Accumulated Variables in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_accumulated_variable.htm&release=264.0.0&type=5 "An accumulated variable is like a running total, where Salesforce Spiff sums a field or value within a sorted data filter and returns a cumulative value up to a current record. An accumulated variable helps you quickly sum multiple values with fewer calculations.") - [Considerations for Accelerator Functions in Salesforce Spiff](https://help.salesforce.com/s/articleView?id=sales.spiff_accelerator_functions.htm&release=264.0.0&type=5 "Salesforce Spiff provides several functions that support accelerators, including mamount(), mpercent(), range_lookup(), and tier_payout.") - [mamount](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mamount.htm&release=264.0.0&type=5 "Returns the commission total for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission rate instead, use the mpercent() function.") - [mpercent](https://help.salesforce.com/s/articleView?id=sales.spiff_function_ref_mpercent.htm&release=264.0.0&type=5 "Returns the commission rate for a deal in Salesforce Spiff, based on a range table and the rep's current attainment. To return a commission total amount instead, use the mamount() function.")