Doing a running total calculation?

Question

I've created a "drawdown sheet" that tracks reoccurring payments/invoicing on a PO. I can't do it as a spreadsheet because it attaches to the pertinat PO which is a PDF. A drawdown will have the starting balance (the amount for which the PO is written) and show the running balance as each weekly billing is paid. I've attached a screen shot of the form and the issue. The calculation is a simple subtraction from the previous balance but the issue is that the formula is performed down the sheet. I tried to do an if,then statement: If "2amount" is > 0 then "1balance" - "2amount", if else then leave "$0.00". Obviously that isn't Javascript but that is my problem - I don't spreak Javascript. I scoured the web to find a solution and selfmedicate but it wasn't in the cards for me. I even watched tutorials on basic javascript related to Acrobat but nothing stuck. HELP!!

ls_rbls · Accepted Answer

Seems like you have all the balance fields assigned with the same fieldname.

You'll need to rename them to fix that first.

I am not sure if, from you've explained, that the next new balance should be shown in the field right below the prior one, and when a new amount is entered in the amount filed to its left.

If that is the case then you need to use a custom calculation script.

In my examlple below I renamed the fields Amont1, Amount2, Amount3, etc for all the amount fields under that column. Then I also renamed all the new balance fields like Balance1, Balance2, Balance3, etc under that column.

In my example script below I using for the first Balance field this line:

event.value = 0;

if (this.getField("Amount1").value >= 1)  event.value = this.getField("Starting Balance").value - this.getField("Amount1").value;

On the next Balance field this line:

event.value = 0;

if  (this.getField("Amount2").value >= 1)  event.value = this.getField("Amount2").value - this.getField("Balance1").value;

On the third balance field:

event.value = 0;

if  (this.getField("Amount3").value >= 1)  event.value = this.getField("Amount3").value - this.getField("Balance2").value;

And so on...

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded