Complex Calculation Treating Negative Numbers as Zero in PDF Form

Question

I need a javascript for Complex Calculation where Total + SAI + Pell = Need; but if SAI is a negative number, treat as zero. Can anyone please assist me?

Nesa Nurani · Accepted Answer

Use this in "Need" field as custom calculation script:var total = Number(this.getField("Total").valueAsString);var sai = Number(this.getField("SAI").valueAsString);var pell = Number(this.getField("Pell").valueAsString);event.value = total + Math.max(0, sai) + pell;

Rene Andritsch · Answer

Hi @jeremy_1903 when looking for scripts to validate or calculate something in Acrobat I found that ChatGPT returns very useful code. Please check the code if it does exactly what you are looking for because it was generated.

For your example this would be:

// Function to safely get a numeric value from a field
function getFieldNumber(fieldName) {
    var field = this.getField(fieldName);
    return field && field.valueAsString !== "" ? Number(field.valueAsString) : 0;
}

// Get values from form fields
var pell = getFieldNumber("pell");
var sai = Math.max(0, getFieldNumber("sai")); // Ensure SAI is non-negative
var total = getFieldNumber("total");

// Calculate the sum
var need = pell + sai + total;

// Set the calculated value in the "need" field
this.getField("need").value = need;

See a screen capture of it working here:

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.