In Queries Tool Negative Numbers Show as Positive

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Within the Queries (beta) module, if the query should return a negative value, it will return the value as a positive number.

Steps to Reproduce: 
1. Create a situation where a negative numeral value might display, for example:
Create a Cost Plan, and for a Cost Plan details make the cost value a negative number.
2. In the MUX go to Administration, and Queries. Make a new query, and select the cost plan information with a query like:

select name,total_cost from fin_plans

Expected Results: 
Negative values should display as a negative number

Actual Results:
The number looks like a positive value

Workaround: 
None

Environment

Clarity 16.4.2

Cause

DE205125

Resolution

The resolution for this is included in

• Clarity 16.4.3