How can i sum the amt_points_earned column with the same [employee] using virtual column?

[Audit_CKGoC]

[Aurelien]

Hi @Audit_CKGoC

You did not share your table structure so it’s hard to tell, but:

• assuming you have a table “Person”
• assuming the table you show is named “Score”, and its column bpar_i_person_i_clerk is of type Ref, refering to table Person
• assuming amt_points_earned is of type Decimal

You may want, in table “Person”, add a virtual column and use this expression:
SUM([Related Scores][amt_points_earned])
For reference:

help.appsheet.com

List Dereference

Dereference the items of a list in bulk to produce a list of the resulting values.