calculation help - (Q1*$1)-(DISC1/100) and SUB is empty IF 0

Question

Attached is a link to the photos of my invoice form. I have the following columns:

Q=QTY.

$=$

DISC1=DISCT.

SUB=SUBTOTAL

I would like the subtotal to accurately calculate from the corresponding row values. Essentially the calculation of (Q1*$1)-(DISC1/100) so that the discount column presents as 35% instead of .35 when I present it to clients.

Then, how do I code SUBTOTAL as empty when the corresponding rows are empty.

victoriap31769655 · Accepted Answer

You need a simple if-condition. See: https://acrobatusers.com/tutorials/conditional-execution

thank you! those articles in conjuction were perfect for my puzzle. I ended up with this:

event.value = (this.getField('Q1').value && this.getField('$1').value && this.getField('DISC1').value) ? ((this.getField('Q1').value*this.getField('$1').value)-(this.getField('DISC1').value/100)) : "";

Test Screen Name · Answer

It is best not to ask "how to code" because it can be seen as just asking us to write your code for you. Most of us are more interested in giving you what you need to learn how to write your own.

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.