Sum query

JamesG2806

Hi I am looking to do a sum up query on this workflow so I have lots of accounts and a total at the bottom. These have been exported from other systems and imported to alteryx. The colums are shown below, I want to get the debit to add up and match the total figure. Is there a way do do a sum but to not count the first field and last field of a column. 

Account		Debit
BMO (Distribution)		458
CIBC		0
GIC		0
		120177.31
		88645.86
		0
Petty Cash	Andrea	0
Petty Cash	Liz	0
PETTY CASH	David Vanstone	0
addd		0
PETTY CASH	Valerie Cardinal	500
kwa		3910
spare		0
Total		213691.17

BenMoss

Hi @JamesG2806 ,

'Is there a way do do a sum but to not count the first field and last field of a column.'

I would apply the following logic to remove these records.

1. RecordID your dataset.

2. Use the sample tool to skip the first 'N' records (n being 1).

3. Sort your data in descending order, based on the record ID field.

4. Use the sample tool to skip the first 'N' records (n again being 1).

Now you have a datastream which excludes both the first and last row; you can now use a summerize tool to consolidate these figures.

Ben