How to add two numerical fields together

[#1]

I have Software amount and Services amount -- want to create a new field that adds the number values together across each row. A total deal value field.

How is this done?

[anbu1984 · Accepted solution]

In Script,

Load

SoftwareAmount,

ServicesAmount,

SoftwareAmount + ServicesAmount As DealValue

From Table

[jerem1234]

something like:

Load .....,

SoftwareField+ServicesField as DealField,

...

FROM ...

Hope this helps!

[Anonymous]

Hi,

In your script in the table where you get your original fields Software amount and Services amount add a new field DealValue.

You can keep Software amount and Services amount if needed otherwise you can leave them.

Example:

FinalTable:

Load

SoftwareAmount, // if you don't need this field anymore just forget this line

ServicesAmount, // if you don't need this field anymore just forget this line

(SoftwareAmount + ServicesAmount) as DealValue

From

YourTable