Reporting - Conditional Formatting inconsistency In Tables

Products

• Clarity PPM SaaS

Issue/Introduction

The responsive reports do not highlight cells consistently despite meeting defined rules.

The conditional formatting rules were created and use the calculated data type number to colorize/highlight the column

STEPS:

1. On the project object, create an attribute that is a calculated data type with a result data type = Number

2. Go to Modern > Reporting > Report Designer > Create or open a responsive report.

Select the report and click Edit.
Include the created attribute in a report table widget.

 

3. Apply the following conditional format rules to colorize a particular field/column cell.

 

a. Field value less than 200 - use Yellow

b. Field value between 201 and 299 - use Orange

c. Field value equal or greater than 300 - use Red

 

Enable/Apply the rules.

 

4. Publish and review the report.

 

Expected: All cells meeting the criteria should be shaded or colorized according to the rules․

 

Actual: Column cells do not colorize, even with values falling within the specified rule ranges․

 

Numbers between 200 and 299 should highlight orange, and 300+ should highlight red, but some cells remain white/unhighlighted, however

certain ones are not colorized. 

Cause

DE183767

The associated data type value for the ones that are not colorized is due to it being represented as a string, instead of a number
when comparing one that is colorized versus one that is not colorized.

Resolution

The issue is not able to be reproduced 16.4.1 or 16.4.2

In 16.4.2, there is enhanced display mapping capabilities where custom display mappings can be configured at the data provider level for ranges and conditional formatting for group rows and total row.