web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Running Balance in cus...
Small and medium business | Business Central, N...
Suggested Answer

Running Balance in custom table

(1) ShareShare
ReportReport
Posted on by CU18011814-0 2
Hi Dynamics Community,
How can I achieve a running balance by currency on a page?
Below is the reference table, showing how I want the running balance to be calculated.
 
Entry No. Amount Currency Running Balance
1 12 USD 12
2 21 AED 21
3 13 USD 25
4 13 USD 38
5 12 AED 33
6 12 USD 50
Categories:
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    Vahid Ghafarpour Profile Picture
    Vahid Ghafarpour 12,090 Super User 2025 Season 2 on at
    I think a calculated column that calculates the running balance will help you. You can use the SUM function to sum the amounts up to the current row.
     
     
  • Suggested answer
    Khushbu Rajvi. Profile Picture
    Khushbu Rajvi. 20,275 Super User 2025 Season 2 on at
    You can use a FlowField with a Sum calculation formula in the table to dynamically compute the running balance based on filters for currency and entry number. This method ensures that the Running Balance field updates automatically based on the current state of the table.
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 95,329 Super User 2025 Season 2 on at
    Hi, Or you can try the following solution to display the total in a Factbox.
     
    Hope this helps.
    Thanks.
    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans