Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Balance column on powe...
Finance forum
Unanswered

Balance column on powerapps

Posted on by
Hello, I need to calculate the balance in a data table displayed on a PowerApps screen. What is the best way? Any suggestion?
Here below is a copy of my table, and a print of my scenario.
The table items have a formula that filters the account selected in a gallery above. Does anyone know what formula or path I should use to get this balance?
 
 
 
 
 
Budget forecast table
 
NOTE: (values ​​can be added between existing lines, which requires the balance to be automatically recalculated according to the inclusion of entries, however it cannot be changed as the user uses date or name filters)
 
 
If it were an Excel spreadsheet, it would just add the value of this column in the previous line with the value of the column next to it. Something like /=B1+A2/
 

Helpful resources

Quick Links

Dynamics 365 Community Update – Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,277 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,126 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans