Modelling issue and totals

[peterhui50]

The Responses Table are respondents response to a sample survey, one individual can have multiple responses. Individuals have their IDs.

The  Table Join Table is a column of unique IDs

The  Table Hours are hours individuals worked by month

Here is a look at the model right now

I noticed when I want to slice hours worked by responses, the total never adds up! 

I basically want the totals add up.

[negi007 · Accepted solution]

@peterhui50  Yes, it will not add up. if you look at your hours table, total of hours column is 10.00 so total will not exceed 10. However, in your response table, sameID is being used against multiple responses so your sub-total at response lavel would have overlapping values so total of sub-total values will be different from the acutal total in the hours table. i hope you understand the logic. In an ideal scenario, each response should be assinged an unique ID so total hours are calculated correctely at the sub-total level of response.

[peterhui50 · Accepted solution]

Thank you, that makes sense.

[negi007 · Accepted solution]

@peterhui50  Yes, it will not add up. if you look at your hours table, total of hours column is 10.00 so total will not exceed 10. However, in your response table, sameID is being used against multiple responses so your sub-total at response lavel would have overlapping values so total of sub-total values will be different from the acutal total in the hours table. i hope you understand the logic. In an ideal scenario, each response should be assinged an unique ID so total hours are calculated correctely at the sub-total level of response.