SUM Expression: How to SUM from two tables?

Hello!

I would like to know if I can SUM up these two as one.
(SELECT(PARTICIPATION[Dosage],[Student ID]=[_THISROW].[Student ID]))
(SELECT(REFERRAL[Dosage],[Student ID]=[_THISROW].[Student ID]))

Please advise. Thank you.

Solved Solved
0 8 835
1 ACCEPTED SOLUTION

You should be able to read it directly from related child virtual lists likeโ€ฆ
SELECT([RelatedParticiptions][Dosage],TRUE)+SELECT([RelatedReferrals][Dosage],TRUE)

View solution in original post

8 REPLIES 8
Top Labels in this Space