How to put a RunningTotal in ERP Navision 2009 Report like Customer Transaction Detail Report?

xhirvana

Hi I am a Beginner here, we have a Customer Transaction Details Report in our ERP Navision 2009, which has Amount & Remaining Amount (LCY) Column. My Boss requested me to put another column for Running Total/Cumulative Sum for the Remaining Amount (LCY). Please, any advice how to put this? Thank you.

aripermadi

create a variable to store the cumulative sum and assign the value on OnafterGetRecord of your detail data item .

example : RemAmoutLCYSUM := RemAmoutLCYSUM + Remaining Amount (LCY)

use the variable as expression for your new column

aripermadi

create a variable to store the cumulative sum and assign the value on OnafterGetRecord of your detail data item .

example : RemAmoutLCYSUM := RemAmoutLCYSUM + Remaining Amount (LCY)

use the variable as expression for your new column

xhirvana

Thank you! We have upgraded now to Business Central🙏