MUX Reporting: Query based attribute with decimals

Products

• Clarity FedRAMP
• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

In MUX Reporting, I have got a query based Data Provider that refers to an attribute with decimals. The generated report though displays the number as integer regardless of the Number Decimal Display format being 0.00

Is this expected?

Environment

Clarity 16.4.1

Resolution

Look at the Reporting Data provider query Attributes tab Extended Data Type value

Query example:

SELECT mydec,
  round(Sum(1) / Sum(3), 2) percentage
FROM dwh_inv_project
GROUP BY mydec

If the attribute referring to comes from a defined Database column ( Clarity object attribute), the Extended Data Type will show double.

If the attribute is calculated in the select statement of the query, the Extended Data Type will show blank.

If the Extended Data Type is blank, the report will not display decimals regardless of the Number Decimal Display format being 0.00

 

Additional Information

If you would like to enhance this product area, please raise an Enhancement