We have a question in regards to matching percentages when combining two tables with a one to many relationship.
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.
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.