Views - Columns aggregated using Sum and grouped by objectId of user is producing strange results

General
4

Hello @James_Greff

Let’s take the FinancialExpense table as an example:

Users   CurrentMonthFinancial 
user1   100
user1   100
user1   100
user2   50

After you group by Users, you get two groups:
First group

user1   100
user1   100
user1   100

Second group

user2   50

Then you summarize CurrentMonthFinancial in groups

Users   Sum CurrentMonthFinancial 
user1    300
user2    50

That is, you get the expected result

You can choose not to group or summarize. You can change the relays to not from the CurrentMonthFinancial table to the Users tables, but from the Users table to the CurrentMonthFinancial table. It all depends on what kind of result you want to get.

Perhaps our documentation will be useful to you:
Data filtering
Aggregate Functions Overview
SUM