A new home for the Coupa Supply Chain documentation
Starting with Supply Chain 42, our documentation will be located on Coupa Compass. The help here will continue to be accessible for the foreseeable future, but will no longer be updated. If you need a Compass user account, contact your company’s Designated Support Contact (DSC).
You can access new and updated Supply Chain documentation in the following location on Compass:
https://compass.coupa.com/en-us/products/supply-chain-design-and-planning
CumulativeSum function
The CumulativeSum function returns the running total of a sequence of numbers. A running total is the summation of a sequence of numbers which is updated each time a new number is added to the sequence by adding the value of the new number to the previous running total. Float and Integer data types.
Ascending order is used by default, but the Desc option can be used to change the order to a descending order. In the Statement Editor interface, select the Desc icon 
to switch to descending order. In the Statement Text Editor, add DESC to the function.
The CumulativeSum function can be used to help create a running cumulative percent of an entire table or a running percent of total (Pareto analysis).
This function requires also using the OrderBy() function. The PartitionBy() function is optional. The best practice is to use a Rank function with CumulativeSum, as the CumulativeSum function groups members with the same value, which may cause the function to calculate values differently than expected when there are duplicate values.
Last modified: Friday May 12, 2023
