TSV data decreases when values are entered outside the set Date constraints

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

TSV data drops when values are entered and saved outside of the Time-varying Date Constraints. 

Steps to Reproduce: 

1. Create a API enabled custom subobject with Master object = Project
    
2. Create two custom API-enabled date fields on the custom subobject which is to be used as Date constraints in the TSV field
   Attribute names: Custom Start and Custom Finish
    
3. Create a custom time-varying attribute with properties:
   Attribute Name: TSV TEST
   Data Type: Time-varying
   Time-varying Type: Calendered
   Time-varying Data Units: Number
   Time-varying Date Constraints:
   Start On: Custom Start
   Finish On: Custom Finish
    
4. Create a custom Project blueprint and add the subobject as a module
    
5. Create a project against the custom blueprint
    
6. Open the custom subobject module and show the custom per-period metric TSV TEST and custom date columns Custom Start and Custom Finish
    
7. From grid view options set :
   Periods as Months
   Start Period = Start of Current Year 
   End Period = End of Current Year
   Enable Grand Totals
    
8. Create an instance of the custom subobject and fill in the date constraints:
   Custom Start: 01/01/2024
   Custom Finish:31/12/2024
    
9. Enter values like 100 in TSV for the displayed 12 monthly periods for 2024 and observe Grand Totals is 1200 as expected
    
10. Now enter values in monthly periods outside the date constraints (2023 or 2025) and observe that the values entered outside the Date constraints are ignored as expected, but observe the grandtotals and monthly cell values in 2024

Expected Results: 
The grandtotals to remain untouched at 1200 and TSV cell values in 2024 at 100 each

Actual Results:
The grandtotals reduces from 1200 and TSV values in 2024 from 100, and the value keeps reducing each time a value is entered outside the date constraints.

Environment

Clarity 16.2.2

Cause

DE94917

Resolution

DE94917, in review by Engineering