how do i add and subtract more than one field

Forum|Forum|10 years ago
April 6, 2016
1 reply
587 views

I have 4 fields

field1 is the begining balance

field2 is amount collected (i want to add this to the field1)

field3 is refunds (i want to subtract that from the total of the first two)

field4 is checks written (again I want to subtract this from the top three)

field5 is where I want the ending balance to go

How do I write this. Do I use script or simplified?

This topic has been closed for replies.

try67

Community Expert

You can use the simplified calculation script of field5, like this (if I understood you correctly):

(field1 + field2) - (field3 + field4)

L

lindac88Author

Participant

I just tried that. But the number is not showing up. It is not giving me an error. I recopied all the field names. They don't have any spaces in them. Should their be spaces between the + and the - in your equation?

try67

Community Expert

Spaces are not necessary, but might be helpful.

Check the JS Console for errors (Ctrl+J). Also, keep in mind the script will only "kick in" when you change the value of one of the fields after you enter it.

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