browse_total_rows

[kknm]

error.PNG

Used browse_total_rows from nuBuilder4-Code-Library.
I have a strange output in 1 column(SUM), with the same formats in other columns (input=Number).

[kev1n]

The image is not displayed. Can you upload it again?

[kknm]

The image is not displayed. Can you upload it again?

Uploaded a new one, sorry I have not yet mastered the forum

[kev1n]

What output do you get when you enter this in the developer console (Press F12 to bring up the browser's Developer Console)

Code: Select all

window.nuFORM.getCurrent().browse_columns[2].format

[kknm]

What output do you get when you enter this in the developer console (Press F12 to bring up the browser's Developer Console)

Code: Select all

window.nuFORM.getCurrent().browse_columns[2].format

in console - ""
Even when choosing a format, the sum in the first calculated column is float, in the rest the integer

[kev1n]

Please also run this code in the dev. console and post the output here:

Code: Select all

var c = window.nuFORM.getCurrent().browse_columns;
var x = "";
for (var index = 0; index < c.length; ++index) {
    x = x + "\n Column " + index + " : " + c[index].format;
}
alert(x);

[kknm]

Please also run this code in the dev. console and post the output here:

Code: Select all

var c = window.nuFORM.getCurrent().browse_columns;
var x = "";
for (var index = 0; index < c.length; ++index) {
    x = x + "\n Column " + index + " : " + c[index].format;
}
alert(x);

Screenshot .PNG

[kev1n]

It looks like no number format was selected.

https://streamable.com/3ckatd

[kknm]

It looks like no number format was selected.

https://streamable.com/3ckatd

Did everything by reference, but the sum = 3226.2, although it should be 3226.3

[kev1n]

It looks like no number format was selected.

https://streamable.com/3ckatd

Did everything by reference, but the sum = 3226.2, although it should be 3226.3

That's because nuBuilder's addFormatting() does not round correctly from a mathematical point of view. It just trims off the additional decimal places.

Code: Select all

nuFORM.addFormatting(3226.29, "N|1000.0")

outputs 3226.2

but

Code: Select all

(3226.29).toFixed(1);

rounds to 3226.3