search cancel

Legacy Classic UI Grid view portlet rounding on Totals is not accurate

book

Article ID: 244046

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

Grid view portlet rounding on Totals is not accurate. 

Steps to Reproduce:  

  1. Define an NSQL Query that would pull back numbers with decimals using round() on METRIC portion of the query 
  2. Include this in a portlet 
  3. Include the portlet in a portlet page 
  4. Add the portlet page to a view 

Expected Results: Totals are accurate when using round() or trunc(). 

Actual Results: Totals are significantly different than when not using round(). 

Environment

Release : 16.0.2

Component : Clarity Studio

Resolution

DE65457 was determined to be 'Works as Designed'. 

In the NSQL query look for another round section in the query 
ROUND(SUM(adj_pipe),0)
 or 
ROUND(SUM(adj_pipe),5) 
 
To be more accurate, we would suggest using the latter: 
ROUND(SUM(adj_pipe),5) 
 
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.