Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
I guess you just need a simple sum like the following:
Load
Account,
Scarfs,
Shirts,
Pants,
(Shirts + Pants) as Sum
From
yourfilepath
Regards
I guess you just need a simple sum like the following:
Load
Account,
Scarfs,
Shirts,
Pants,
(Shirts + Pants) as Sum
From
yourfilepath
Regards
Hi,
if you just want to present this column, you could do so as a chart expression instead:
hope this helps
regards
Marco
Thank you for the Replies, those answered the question perfectly.
Bill
you're welcome.
regards
Marco