I have a number of tables where each object is related to users 1:1. Each table contains financial data and uses generated columns to sort and summarize the financial data. The generated columns are working well in each individual table. Ultimately I would like to aggregate (sum) these generated columns by user.
However, the views that I have created are behaving in unexpected ways. The first column in the view is the objectId of the user. Each additional column is a generated column from related tables, aggregated using SUM. The aggregated columns are grouped by objectId. The values produced for each user are often 100X what I would expect.
I would like each object in the view to contain summed data that relates only to the individual user.
Am I doing it wrong?