add two fields from different tables

[arulsettu]

hi

i need to add two fields from different tables. and check with condition like values > 0  and display it in chart for current month

any suggestions ?

[phaneendra_kunc]

May be it will help if you elaborate little more to the community.

[arulsettu]

hi

for example field1 from table1

and field two from table2

i need to add these two fields and check these fields value > 0

[phaneendra_kunc]

so some thing like below ?

=if(Sum(Field1)+sum(Field2) > 0, 'TRUE','FALSE')

[arulsettu]

any help?

[anbu1984]

What is the join key?

[arulsettu]

condition like

orderquantity - shipped quantity

so it will check the values > 0

[arulsettu]

item number is join key

[arulsettu]

mapping load with apply map would be helpful for this scenario?

[arulsettu]

can you suggest any idea?