Getting value from a different Object

[Anonymous]

All,

I'm trying to see if you can get value from a different Table.

For example: For table 2 - I want field Company and Date, as well "Total" column from  table 1 (not Sum(vaule1,vaule2, vaule3)

Is there expression where you can reference table1 fields/columns?

Table 1:

Company	Date	Value1	Value2	Value3	Total
ABC	3/1/2016	1	2	3	6
XYZ	3/1/2016	7	8	9	24

Table 2:

Company	Date	Total
ABC	3/1/2016	6
XYZ	3/1/2016	24

Thanks,

Frank

[maxgro · Accepted solution]

try with

RangeSum(Value1, Value2, Value3)

int the 2nd table

[Anonymous]

Thanks.. It works.

[Anonymous]

how do rangsum a column or Label name? Thanks