Simple Sum Function in Load Script

[#1]

Hello,

I am trying to get the Sum column in the following example which is Shirts plus Pants

Account	Scarfs	Shirts	Pants	Sum
ACCT 1	$3.00	$12.50	$6.00	$18.50
ACCT 2	$6.00	$24.00	$5.00	$29.00
ACCT 3	$7.00	$0.00	$125.00	$125.00

Account, Scarfs, Shirts and Pants are fields in my data source. I want to accomplish this sum so that there is now a field called sum and it is the sum of each row for Shirts and Pants. I don't need a sumif of specifc accounts, just a sum of all accounts shirts and pants. Thanks,

[caio_caminoski · Accepted solution]

I guess you just need a simple sum like the following:

Load

     Account,

     Scarfs,

     Shirts,

     Pants,

     (Shirts + Pants) as Sum

From

yourfilepath

Regards

[MarcoWedel]

Hi,

if you just want to present this column, you could do so as a chart expression instead:

hope this helps

regards

Marco

[#4]

Thank you for the Replies, those answered the question perfectly.

Bill

[MarcoWedel]

you're welcome.

regards

Marco