Total 3 Columns

[mwscott1]

I have two tables both joined by column REF Number. I need to know how to total the other three columns

Table 1

REF Number	Candidate Submitted
R0001	1

Table 2

REF Number	Interview Scheduled	Candidate Appointed
R0001	5
R0001		10

Candidate Submitted + Interview Scheduled + Candidate Appointed = 16

[sunny_talwar · Accepted solution]

May be use RangeSum() function

RangeSum(Sum([Candidate Submitted]), Sum([Interview Scheduled]), Sum([Candidate Appointed]))

[mwscott1]

Is it possible to include this in the load so that it loads a "Total"

[sunny_talwar]

In the load you can do this:

RangeSum([Candidate Submitted], [Interview Scheduled], [Candidate Appointed]) as SumOfThreeFields