Known Participant

Answered

Calculating sum of multiple fields minus one or two fields in one form field

I cannot find a way to calculate a total of multiple fields and then subtract all in the same text form field...is there a way to do this?

eg: TOTAL ASSETS 1 + TOTAL ASSETS 2 - LIABILITIES 1 + LIABILITIES 2

This topic has been closed for replies.

Correct answer PDF Automation Station

Enter the following custom calculation script:

event.value=

this.getField("TOTAL ASSETS 1").value+

this.getField("TOTAL ASSETS 2").value-

(this.getField("LIABILITIES 1").value + this.getField("LIABILITIES 2").value);

Community Expert

If this what you want to calculate, use simplified field notations just escape space character in your field names with backslash like this:

TOTAL\ ASSETS\ 1 + TOTAL\ ASSETS\ 2 - LIABILITIES\ 1 + LIABILITIES\ 2

Known Participant

Thank you very much!

Community Expert

Are those field names?

Correct answer

Community Expert

Enter the following custom calculation script:

event.value=

this.getField("TOTAL ASSETS 1").value+

this.getField("TOTAL ASSETS 2").value-

(this.getField("LIABILITIES 1").value + this.getField("LIABILITIES 2").value);

Known Participant

Thank you so much!

Sign up