How to subtract previous line data in time new line insert

mistu2020
mistu2020 Member Posts: 15
edited 2014-02-11 in NAV Three Tier
LOAN CODE EMP. CODE APPROVED LOAN AMT. MONTH YEAR EMI AMT. CUMULATIVE BALANCE
comp loan 285 20,000.00 april 2014 670 (20000-670)=19,330.00
comp loan 285 20,000.00 may 2014 670 (19,330-670)=18,660.00

I want to do this in time of new record insertion.

How to do this???

Please help

Answers

  • StLi
    StLi Member Posts: 83
    what's the exact problem? why don't you just modify the existing line?

    edit: actually: a flowfield would be the way to go if you want to have the sum of the value from the subline in the related line.
  • MBerger
    MBerger Member Posts: 413
    i wouldn't calculate this at time of insertion....what if you'd delete an earlier line sometime later, because of a mistake or something ? Your sum wouldn't be correct anymore.

    What you could do is the opposite : make a flowfield that calculate the total amount of this and the previous lines ( SUM of LOAN AMT. for all lines with the same Loan code, emp code etc. where Date <= Date of the line. You might have to add a proper date to your table though...what you have now isn't really up to the task )

Categories