Queries Tool - Decimals are rounding to whole number, even when query specifies a decimal

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When attempting to use the ROUND function in a query, in the Administration Queries module, attempting to round to a decimal number still rounds to a whole number.

 

Steps to Reproduce: 
1. Within the MUX Administration access the "Queries" module
2. Create a new query, and within the query include ROUND with a decimal, for example:

SELECT code cost_plan_id, name cost_plan_name,
                      ROUND(total_cost, 2)
FROM fin_plans

Expected Results: 
The number should be rounding to a specific decimal point

Actual Results:
The number rounds to a whole number in the Queries results

Environment

Clarity 16.4.2

Resolution

This is under investigation and being tracked as DE207769