search cancel

Discrepancy in Jaspersoft Report - Financial Forecast Review by Plan Grouping

book

Article ID: 202639

calendar_today

Updated On:

Products

Clarity PPM SaaS Clarity PPM On Premise

Issue/Introduction

If the input parameter Financial Plan Type = Budget, the result field 'Forecast (Calculated)' does not equal to the Budget Forecast total in the project > financial plan tab.

 

 

 

 

 

Environment

Release : 15.8.1

Component : CA PPM SAAS APPLICATION

Resolution

This is by design as per code review/analysis by our Development team:

When running with parameter Group By Budget, the field  Forecast(Calculate) does not populate. it goes to 0.0

As per code:
SUM(CASE WHEN fp.fin_plan_type_key = 'FORECAST' THEN pf.fcst_cost ELSE 0 END) forecast,

If it is Planned (FORECAST) it uses fcst_cost, otherwise it is zero.