Hi, really apreciate any help on this one.
I have Table students and table payment.
In table payment i have the column โstudent nameโ wich is ref from column student-name from student table
So when i add a payment i select the student name, so far so good. I even have a โrelated paymentsโ in my students table view.
I need to create a virtual column in the student table that will show me the sum of the amount of the diferent payment of each student . I do have this value in the related payment view Group aggregate SUM:: AMOUNT that is exactly the value that i need to put in a virtual column in student table. I tried this virtual column formula in student table: sum(SELECT(Payment[amount], ([student-name] = [_THISROW].[student-name])))
but its not correct, doesnt add anything.
Thanks in advance
Solved! Go to Solution.
sum(select(Payment[Amount], [student-name] = [_THISROW]))
sum(select(Payment[Amount], [student-name] = [_THISROW]))
Try
Sum(Related Payments[Payment])
I assumed your field that holds the actual amount paid was called Payment, but just change it to the correct one.
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |