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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

How to do Sum of Values In ELECTRONIC REPORTING

(0) ShareShare
ReportReport
Posted on by 71

Hi Community,

In MD365 F&O - Electronic Reporting (ER), how can we calculate the sum of values? I’ve tried multiple approaches but haven’t been able to find a correct solution yet. Could someone please guide me on how to achieve this—specifically, which function or data source types need to be configured to calculate a total in ER?

Categories:
I have the same question (0)
  • Martin Dráb Profile Picture
    239,417 Most Valuable Professional on at
    It depends on what you have as an input, but most likely, you're looking for SUMIF() function. The documentation page also has some links to examples.
  • DB-12110903-0 Profile Picture
    71 on at
    I'm Preparing testing Report Of PO that also include the PO lines and I want the total of (Line-Level) Purch Qty, so how to configure that value? 
  • Verified answer
    DB-12110903-0 Profile Picture
    71 on at
    Thanks It was resolved by Group by Functionality...

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 609 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 561

#3
CP04-islander Profile Picture

CP04-islander 383

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans