Getting Custom Percentage Fact to Return a Correct Value

Summary

Using the Workforce Goals - Goal Status Overview Real Time Subject Area

Content

For a client report we have been asked to display Performance Goal Status Counts e.g. In Progress, Not Started, Completed and associated Percentages. Using the standard count fields e.g. "- Goal Management Process"."Count of Canceled Goals" and filtering on where the Goal Type is Performance and using the standard "- Goal Management Process"."Count of All Performance Goals", I had hoped that calculating the Percentages would be a simple process but it's not. Some of the percentages are calculating correctly but some are not.