Sum of fields

[qvqfqlik]

How to calculate sum of two different fields from two different fields -

sum needs to be calculated in the third table.

field 1  - is sum(x+y+z) as field1

fields 2 - is sum (a+b+c) as field2

in another table i need to calculate field3 which would be field1+field2

Please help

[qvqfqlik]

it worked. I need to test more data. Thankyou Rob

[susovan]

Hi,

You can also try this

Table:

LOAD Product,

     a,

     b,

     c,

     Field1 as @_Field1,

     x,

     y,

     z,

     Field2 as @_Field2

FROM

Test.xlsx

(ooxml, embedded labels, table is Sheet1);

Left Join

Table1:

LOAD*,

(@_Field1+@_Field2) as Total_Amount Resident Table

[rwunderlich]

Great. Please mark something as correct to close the thread.

-Rob

[qvqfqlik]

per requirement I need to use only the Sum function and not rangesum

I am getting script error.. could you please help with this

script error