I have added a ‘project completed percentage’ to a report, PMProject DAC and PMProjectRevenueTotal DAC has a relationship,
But when I add that field to the report it is not display the value, other fields of this DAC also visible in the report.
How can I fix that?
Best answer by DipakNilkanth
Hi
ContractCompletedPct is the calculated field and not existed in database that’s why it is not showing in report.
As Reports and GI’s not able to display calculated fields, I believe you need to use formula to calculate the Completed percentage of project to display the same.
Hope, it helps!
+13Hi
ContractCompletedPct is the calculated field and not existed in database that’s why it is not showing in report.
As Reports and GI’s not able to display calculated fields, I believe you need to use formula to calculate the Completed percentage of project to display the same.
Hope, it helps!
Hi
if we look at the DAC schema below:
We can see that the value is not saved to the DB, this means it is calculated in the below code:
get { if (CuryAmount.HasValue && CuryAmount != 0) return (CuryInvoicedAmount.GetValueOrDefault() + CuryActualAmount.GetValueOrDefault() + CuryInclTaxAmount.GetValueOrDefault()) / CuryAmount * 100m; else return 0m; } }To calculate this in a report, we would look at the get{}, e.g., IIF([PMProjectRevenueTotal.CuryAmount] != 0 AND [PMProjectRevenueTotal.CuryAmount] NOT NULL, (([PMProjectRevenueTotal.CuryInvoicedAmount] + [PMProjectRevenueTotal.CuryActualAmount] + [PMProjectRevenueTotal.CuryInclTaxAmount])/[PMProjectRevenueTotal.CuryAmount])* 100, ‘ ‘)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.