SUM Expression: How to SUM from two tables?

[Kevin_Chan]

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.

[LeventK]

@Kevin_Chan

(SELECT(PARTICIPATION[Dosage],[Student ID]=[_THISROW].[Student ID])) + (SELECT(REFERRAL[Dosage],[Student ID]=[_THISROW].[Student ID]))

[Kevin_Chan]

LeventK:

(SELECT(PARTICIPATION[Dosage],[Student ID]=[_THISROW].[Student ID])) + (SELECT(REFERRAL[Dosage],[Student ID]=[_THISROW].[Student ID]))

WOW! I have been trying with the AND () and I couldn’t make it work but you added a “+” and it works. Thank you.

[LeventK]

You’re welcome @Kevin_Chan

[Aleksi]

Btw… do you have relationships between these tables?

[Kevin_Chan]

@Aleksi Based on this, it looks like these two tables have relationships. Correct me if I’m wrong.

[Aleksi · Accepted solution]

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

[Kevin_Chan]

Aleksi:

SELECT([RelatedParticiptions][Dosage],TRUE)+SELECT([RelatedReferrals][Dosage],TRUE)

@Aleksi, I tried your expression and yes it works. Thank you.

[Aleksi]

With that syntax you don’t need to read two tables totally. You only need to read the virtual related records list.