Gross Profit calculator issue

Question

Trying to determine how to make a gross profit percentage calculation populate in field usgp.

I'm trying to divide usppu/usdcost, multiply by 10, and have the result populate in field usgp. Unfortunately, I'm not getting an error message and the field remains blank.

Note that field usppu populates once uscog (cost of goods) is manually entered and subtracted from usdcost ( i.e. usppu=usdcost-uscog).

Here's what I have so far:

Thank you.

jack_4781 · Accepted Answer

You're right to clarify assumptions—it's important for accurate scripting, especially in a net salery calculator. Based on your notes, here's a cleaner version of the code using valid syntax and better naming:

javascript
var usppu = this.getField("usppu").value; var usdcost = this.getField("usdcost").value; if (usppu && Number(usppu) > 0) { event.value = (usdcost / Number(usppu)) * 10; } else { event.value = 0; }

Make sure "usppu" is actually the field you're intending to check, not "disco" or another checkbox. Also, confirm that this script is applied to the "usgp" field if that’s where the result should appear. This structure makes it easier to add discount logic later for your net salery calculator .

Thom Parker · Answer

The "usppu" field is not a checkbox. I think you must mean for one of the "disco" fields to be used in the "if" statement?

You did not say, but I'm assuming that the script you provided a custom calculation on the "usgp" field? Since this is where you say the result should go. These details are important. Assumptions are bad.

So I would suggest you start out by just doing the straight forward calculation. Then add the discount code.

var oFld=this.getField("usppu");

if(oFld.value && ((Number)oFld.value > 0))

event.value=(this.getField("usdcost").value/(Number)oFld.value)*10;

else

event.value = 0;

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