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
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
Use CALCSUMS
refer https://docs.microsoft.com/en-us/dynamics-nav/calcsums-function--record-
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
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
Why can't you use the Sum function to get the sum of values ?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,280 Super User 2024 Season 2
Martin Dráb 230,214 Most Valuable Professional
nmaenpaa 101,156