How do I calculate Cumulative Values in Bold BI^®?

Published: May 10, 2023

To views the cumulative values in Bold BI^®, the platform includes an expression designer with built-in functions that allow you to create your own expression columns. Let's explore how to calculate the cumulative sum in Bold BI^®.

Calculating Cumulative SUM

Configure the widget with the required columns and click on Add Expression to open Expression Designer window.
In Expression Designer, choose the RUNNINGSUM function from the Functions list and choose the required column. Once saved, new column will be added to the datasource.Expression Editor with Running Sum calculation
Now bind the new added column from the measures to the required widget and you can see the RUNNINGSUM results. Running Sum Expression column added in Grid widget

Bold BI^® has supported below built-in functions for Cumulative value calculation:

Functions	Syntax, Descriptions & Examples
RUNNINGCOUNT	Syntax: RUNNINGCOUNT(aggregate_expression) Description: Returns the running count of each row. Example: RUNNINGCOUNT(MAX([OrderID]))
RUNNINGAVG	Syntax: RUNNINGAVG(aggregate_expression) Description: Returns the running average of each row. Example: RUNNINGAVG(MAX([UnitsInStock]))
RUNNINGMAX	Syntax: RUNNINGMAX(aggregate_expression) Description: Returns the running maximum values of each row. Example: RUNNINGMAX(SUM([UnitsInStock]))
RUNNINGMIN	Syntax: RUNNINGMIN(aggregate_expression) Description: Returns the running minimum values of each row. Example: RUNNINGMIN(SUM([UnitsInStock]))
RUNNINGSUM	Syntax: RUNNINGSUM(aggregate_expression) Description: Returns the running sum values of each row. Example: RUNNINGSUM(MAX([UnitsInStock]))

Additional References:

Was this article useful?

Dislike

How do I calculate Cumulative Values in Bold BI®?

Additional References:

Access denied

How do I calculate Cumulative Values in Bold BI^®?