Skip to main content
Post a question

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Sales Analysis Report Cannot Sum More than 25 Rows

Posted on 31 Aug 2015 01:53:08 by Microsoft Employee

Has anyone had this problem? In sales analysis report for Dynamics NAV 2015 (cumulative update 2, AU version)... if I set a formula to total more than 25 rows, then the field is blank when I click Show Matrix.

I have tested it with 25 rows and it works. If I set a formula to add more than 25 rows, then it is blank.

2015_2D00_08_2D00_31_5F00_8_2D00_37_2D00_05_5F00_small.jpg

2015_2D00_08_2D00_31_5F00_8_2D00_44_2D00_54_5F00_small.jpg

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on 06 Sep 2015 at 09:07:23
    RE: Sales Analysis Report Cannot Sum More than 25 Rows

    It is a new installation.  

  • mmv Profile Picture
    mmv 11,465 on 31 Aug 2015 at 06:36:25
    RE: Sales Analysis Report Cannot Sum More than 25 Rows

    Hi,

    Actually the size of Formula field is just 80 characters (Code), perhaps, your formula text is more than 80.

  • Suggested answer
    Miguel Llorca Profile Picture
    Miguel Llorca User Group Leader on 31 Aug 2015 at 06:23:00
    RE: Sales Analysis Report Cannot Sum More than 25 Rows

    Are you using a new installation or your database is an upgrade from other version??

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

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans