Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV forum
Suggested answer

Report design in nav

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

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 228,651 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans