Fig 1. Tables one to many relationship
When performing a count on the keys used for joining, we get the correct counts when using two number components.
For example:
Number Component 1: COUNT( TableA."_case_key")
Number Component 2: COUNT( TableB."_case_key")
However, when we combine the counts in a single component, and divide them by each other, then we receive the wrong count.
So the component 3 is wrong:
Number Component 3: COUNT( TableA."_case_key")/COUNT( TableB."_case_key")
We suspect the error might be lying in the way the tables are joined. Please guide us in finding a solution, to get the right division.