PPM Calculated attributes using DateDiff impacted on environments using Postgres

book

Article ID: 192816

calendar_today

Updated On:

Products

Clarity PPM SaaS

Issue/Introduction

We have a calculated attribute "% Schedule Gap" = (DateDiff(schedule_finish,baseline_finish,"Day")/+DateDiff(baseline_finish,baseline_start,"Day"))*100

We have noticed this attribute is not correctly displayed on GCP environment

The result of this calc is not displaying correctly on GCP Production environment 

In comparison Test environment, which is currently NOT GCP, has valid numbers 


Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

DE55738

Resolved in GCP 15.8.1 maintenance