Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be use RangeSum() function
RangeSum(Sum([Candidate Submitted]), Sum([Interview Scheduled]), Sum([Candidate Appointed]))
May be use RangeSum() function
RangeSum(Sum([Candidate Submitted]), Sum([Interview Scheduled]), Sum([Candidate Appointed]))
Is it possible to include this in the load so that it loads a "Total"
In the load you can do this:
RangeSum([Candidate Submitted], [Interview Scheduled], [Candidate Appointed]) as SumOfThreeFields