Precending load

[#1]

here's my problem, i have two excel files, every file has a lot of fields for example,

first file,

file 1;

load

A

B

C

D

E

FROM file1;

second file

X

H

J

G

M

N

FROM FILE 2

what i want to do is:

take the field B and the field M and make the sum.

that's all.

thank's for help

[ashfaq_haseeb · Accepted solution]

Hi,

Try like this in a text box

=sum(B)+sum(M)

Regards

ASHFAQ

[JonnyPoole]

Is the data related ?  For example, are all the fields the same  (ie:  A=x , B=H, C=J etc...) ?

[anbu1984]

What is the join key for two files?

[#5]

no, the fields are not the same , and when i do sum(B)+sum(M) i've got an error.

[#6]

there's no join key.

[ashfaq_haseeb]

Hi,

Did you try my solution?

If possible share sample data.

Regards

ASHFAQ

[#8]

yes i did but i've got an error

[#9]

where i should write sum(B)+sum(A)??

[ashfaq_haseeb]

Create new text object and write below code.

=sum(B)+sum(M)

Modify your fields accordingly.

Regards

ASHFAQ