Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Sum of First()

Posted on by 3,027

Hi

 In SSRS Report i have value in 1 column like below

First(Test!Value)

In the end i want to Sum the value of this column

Thanks

*This post is locked for comments

  • Suggested answer
    CDsilva Profile Picture
    CDsilva 4,184 on at
    RE: Sum of First()

    Use CALCSUMS

    refer https://docs.microsoft.com/en-us/dynamics-nav/calcsums-function--record-

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Sum of First()

    Create custom functions and  pass that value to function and sum the value in the function, call another function to return the value. Check an example here

    Dim Total As Decimal
    
    Function AddGroupTotal(ByVal TotalToAdd As Decimal)
        Total = Total + TotalToAdd  
    End Function
    
    Function GetTotal() As Decimal
        Return Total
      End Function
  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Sum of First()

    Hi

      When i write Sum(First(Test!Value)) then it gives error . I have grouping On No . I want to show Sum in the footer of only First Value of each grouping

    Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,745 on at
    RE: Sum of First()

    Why can't you use the Sum function to get the sum of values ? 

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