Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Report design in nav

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

How do i calculate average price in the sales price table?

I want the average price to appear on my following report.

7587.nav.PNG

  • Suggested answer
    THE Italian Profile Picture
    THE Italian on at
    RE: Report design in nav

    You have to be in touch with your CSP Partner / Reseller developer and ask them to code for you.

    Basically a function might be created that sum up all UnitPrice value per Item and then it divide the value for the number of entries.

    Your developer have to evaluate, then, if these has to be added as a calculated field in the table or calculate the value on the fly (it depends what use you want to do with this field - if this is for this report only then a function to calculate might be the good choice -).

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Report design in nav

    thanks to those who will help

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans