Calculate the variables and the result is incorrect.

[LTCTHITA]

Hey,...

I calculate the variables At first there were 10 variables and the calculations could be done correctly, but when the variables were increased to 30, the resulting numbers increased from tens of thousands to hundreds of thousands.


The code used is

function sumVariables(...vars) {
return vars.reduce((sum, current) => sum + (Number(current) || 0), 0);
}
let c1 = $("Scan.Fields.Var Count 1")
let c2 = $("Scan.Fields.Var Count 2")
let c3 = $("Scan.Fields.Var Count 3")
let c4 = $("Scan.Fields.Var Count 4")
let c5 = $("Scan.Fields.Var Count 5")
let c6 = $("Scan.Fields.Var Count 6")
let c7 = $("Scan.Fields.Var Count 7")
let c8 = $("Scan.Fields.Var Count 8")
let c9 = $("Scan.Fields.Var Count 9")
let c10 = $("Scan.Fields.Var Count 10")
let c11 = $("Scan.Fields.Var Count 11")
let c12 = $("Scan.Fields.Var Count 12")
let c13 = $("Scan.Fields.Var Count 13")
let c14 = $("Scan.Fields.Var Count 14")
let c15 = $("Scan.Fields.Var Count 15")
let c16 = $("Scan.Fields.Var Count 16")
let c17 = $("Scan.Fields.Var Count 17")
let c18 = $("Scan.Fields.Var Count 18")
let c19 = $("Scan.Fields.Var Count 19")
let c20 = $("Scan.Fields.Var Count 20")
let c21 = $("Scan.Fields.Var Count 21")
let c22 = $("Scan.Fields.Var Count 22")
let c23 = $("Scan.Fields.Var Count 23")
let c24 = $("Scan.Fields.Var Count 24")
let c25 = $("Scan.Fields.Var Count 25")
let c26 = $("Scan.Fields.Var Count 26")
let c27 = $("Scan.Fields.Var Count 27")
let c28 = $("Scan.Fields.Var Count 28")
let c29 = $("Scan.Fields.Var Count 29")
let c30 = $("Scan.Fields.Var Count 30")

// รวมค่าทั้งหมด
let total = sumVariables(c1, c2, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14, c15, c16, c17, c18, c19, c20, c21, c22, c23, c24, c25, c26, c27, c28, c29, c30);

//console.log("Total:", total); // แสดงผลรวม
return total;

---

I put the value in the variable
var count 1 = 17000
var count 2 = 17000
The result must be 34000.
But the result came out to be 357000.
The moment I pressed the button to calculate numbers, it first came up to 34000 and then changed to 357000 itself.

[mikesealey]

Hey @LTCTHITA

I've tried to replicate this issue up to 30 fields, but I've been unable to.

The behaviour you describe - it first came up to 34000 and then changed to 357000 itself - may be to do with the numbers in fields saving when the field loses focus (clicking out of the field).

My suggestion would be to totally simplify your code to try to eliminate possible issues.

Try this:

return
$("Scan.Fields.Var Count 1") +
$("Scan.Fields.Var Count 2") +
$("Scan.Fields.Var Count 3") +
$("Scan.Fields.Var Count 4") +
$("Scan.Fields.Var Count 5") +
$("Scan.Fields.Var Count 6") +
$("Scan.Fields.Var Count 7") +
$("Scan.Fields.Var Count 8") +
$("Scan.Fields.Var Count 9") +
$("Scan.Fields.Var Count 10") +
$("Scan.Fields.Var Count 11") +
$("Scan.Fields.Var Count 12") +
$("Scan.Fields.Var Count 13") +
$("Scan.Fields.Var Count 14") +
$("Scan.Fields.Var Count 15") +
$("Scan.Fields.Var Count 16") +
$("Scan.Fields.Var Count 17") +
$("Scan.Fields.Var Count 18") +
$("Scan.Fields.Var Count 19") +
$("Scan.Fields.Var Count 20") +
$("Scan.Fields.Var Count 21") +
$("Scan.Fields.Var Count 22") +
$("Scan.Fields.Var Count 23") +
$("Scan.Fields.Var Count 24") +
$("Scan.Fields.Var Count 25") +
$("Scan.Fields.Var Count 26") +
$("Scan.Fields.Var Count 27") +
$("Scan.Fields.Var Count 28") +
$("Scan.Fields.Var Count 29") +
$("Scan.Fields.Var Count 30")

[LTCTHITA]

Hey, @mikesealey

It still hasn't.
Previewed results are correct.

But when trying to use it, it works as per the video.

UHT3_Material.Change.Paper.Brik.and.11.more.pages.-.Work.-.Microsoft.Edge.2567-07-15.12-19-47.mp4

The value recorded in the database is the Error value.