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

AppSheet AppSheet Q&A
1

3X_2_d_2d8a0b472813901f59a87a0db19e14cbccea4b46.png
3X_2_d_2d8a0b472813901f59a87a0db19e14cbccea4b46.png632×387 27.2 KB

2

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:

1 Like