DE65457 was determined to be 'Works as Designed'.
In the NSQL query look for another round section in the query
To be more accurate, we would suggest using the latter:
The next step is the Totals Aggregation in the UI
This is performing a calculation for the presentation layer
The Sum capability is limited here.
It does not let us round in the presentation layer for the Totals.
For this part, we would need an enhancement to allow to round to 2 places.
This would be the ideal solution and the most accurate.
To display the most accurate result, we suggest using
ROUND(SUM(adj_pipe),5). However, we are limited in we cannot bring down the display to 2 places.