We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

Weird behavior in the SUM column

Resolved
Stelios asked on March 14, 2022

As I was testing, I noticed a weird behavior in the SUM column.
The generated (from the script) column only sums the integer part of the numbers, while the column I added manually, sums correctly the decimal parts.
(In the image "Total sum of Total" is the generated column, while "GrandTotal" is the column I added manually).
 
Is there something I need to do in the script code??
 
The code for the report I am using:

report: {
dataSource: {data: jsonData},
slice: {
rows: [
{uniqueName: "TaxNumber"},
{uniqueName: "Company Name"}
],
measures: [{
uniqueName: "Total",
aggregation: "sum"
}],
expands: {
expandAll: true
}
},
options: {
grid: {
viewType: "grid",
type: "classic"
}
}
},

 
Kind regards,
Stelios

Nadia Khodakivska created this ticket from #44719

1 answer

Public
Stelios March 15, 2022

Hello, 
 
Please ignore previous request. 
There was an issue with the data we provided the plugin.
It works as intended.
 
Thank you.
 
Kind regards,
Stelios

Please login or Register to Submit Answer