A time-varying money attribute adds .0000000001 with certain values on grid edit

Document ID : KB000007059
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When using a Time-varying Money attribute on a grid portlet that allows edit, certain values (e.g.: 1234567.6, but not 1234657.5) add .0000000001 to the number.

 

Steps to Reproduce:

  1. Go to the Project object.
  2. Add a time-varying money attribute
  3. Go to the Project list view, configure portlet
  4. List Column Section > Fields
  5. Add a new Virtual "Time scaled value" for the attribute. Add it with monthy time-scale and 5 decimals.
  6. Save the portlet
  7. Edit any project adding "1234567.6" as the value for a given month.

Expected Result: Preview shows 1,234,567.60000.

Actual Result: Preview shows 1,234,567.6000000001. Once saved, rounding shows 1,234,567.60000, but trying to edit it back still shows 1,234,567.6000000001

Environment:
CA PPM 14.3, 14.4 and 15.1
Cause:

This is being caused by DE31263/CLRT-81241.

Resolution:

This issue has been fixed in our development branch and it should be included in our next release (v15.3).