Announcements

No record found.

# How to get sum of last amount in rdlc report

Posted on by 129
Hi Guys,
I want to get add value by value & to get sum.
First value will be the same .i .e. 1 & then  add the amount in that total that comes one by one.
like below example , Here I have 2 columns. one is Amount & second is Total.
so in total column ,I want to get sum of last amount value. i.e.  my first total value is 1 & amount value is 2 . so 1+2 =3, 3+3=6, 6+4=10 like this.
Is any way to do this.

• Member 129 on at
How to get sum of last amount in rdlc report
How it done through AL code
• Member 129 on at
How to get sum of last amount in rdlc report
Hi yunzhu, can you give me an idea about done through AL code.
• YUN ZHU 68,586 Super User 2024 Season 2 on at
How to get sum of last amount in rdlc report
As far as I know this can be done in AL, if it is difficult in RDLC, it is recommended to try other ways.

Hope this can give you some hints.
Thanks.
ZHU
• Member 129 on at
How to get sum of last amount in rdlc report
Yes as my requirement is for Customer-to balance report.On that report i want to add Running balance column.
I have write this expression on my text box:
=RunningValue(Fields!OriginalAmt.Value,Sum,"CustLedgEntry1")
=RunningValue(Fields!OriginalAmt.Value,Sum,"DataSet_Result")
=RunningValue(Fields!OriginalAmt.Value,Sum,"No_Customer")
but it is not working. can we do this code throgh?
• Kamal Khakhkhar 255 on at
How to get sum of last amount in rdlc report
hii there,

as per your requirement you need to add Running total for your report , for that i provide a link you can go through it. You can get idea about it.

Thank You,
Kamal Khakhkhar.
• KasparsSemjonovs 3,666 Super User 2024 Season 2 on at
How to get sum of last amount in rdlc report
You would need to add a new Variable, and then filter the amounts based on Line number.
For 1st line, you Sum the amounts with filter Line No. = ..10000, for 2nd line it would be ..20000 and so on. as the line number could be different, You would want to filter .."CurrentLineNo"

#### Dynamics 365 Community Update â€“ Sep 9th

Welcome to the next edition of the Community Platform Update. This is a weeklyâ€¦

#### Announcing Our 2024 Season 2 Super Users!

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

#### Community Spotlight for September 2024

#1

AndrÃ© Arnaud de Cal... 290,326 Super User 2024 Season 2

#2

Martin DrÃ¡b 228,166 Most Valuable Professional

#3

nmaenpaa 101,148