Custom Calculation, Script Help

[katiet1983]

I need help with formulating a custom script for the total precentage discount for section C. (Currently shown as 1234321%). Please help. I cannot figure out the correct order.

[Bernd Alheit]

What script does you use? 

[katiet1983]

I am working in the custom calculation script within Acrobat.

[Bernd Alheit]

What script does you use? 

[try67]

Did you set the field as having the Percentage option selected in the Format tab? If so, the value needs to be between 0 (0%) and 1 (100%). I would recommend switching to the Number format, instead.

[katiet1983]

I do have this set as a Number field.

Would you be willing to look at the document?

[try67]

Sure, but this field has no calculation associated with it...

[try67]

Use this code:

var salePrice = Number(this.getField("Sale Price").valueAsString);
var listPrice = Number(this.getField("List Price").valueAsString);
if (listPrice==0) event.value = "";
else event.value = (1 - (salePrice / listPrice)) *100;

[try67]

And set the field's Format to Number (with 2 decimals).