Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Sales Analysis Report Cannot Sum More than 25 Rows

Posted on 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.

5008.2015_2D00_08_2D00_31_5F00_8_2D00_37_2D00_05_5F00_small.jpg

3441.2015_2D00_08_2D00_31_5F00_8_2D00_44_2D00_54_5F00_small.jpg

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Analysis Report Cannot Sum More than 25 Rows

    The .. symbol does not work. I decided to just do it this way instead.

    2015_2D00_09_2D00_02_5F00_8_2D00_25_2D00_47.jpg

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

    Hi,

    It was my mistake, I just overlooked something.  Instead of using the + symbol in the Range, did you Period (.)

    E.g: R112..R125

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Sales Analysis Report Cannot Sum More than 25 Rows

    The "Range" field in table 7114 (Analysis Line) has a length of 250 characters and is text. Which table are you referring to? Also, my text string is over 100 characters, so I am not sure that this is the issue. -Thanks-

  • mmv Profile Picture
    mmv 11,465 on at
    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.

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans