Batch split in Alteryx

Pascal_R

Hi All,

Any Idea how the formula needs to be adjusted that is working for batch split if its still the same Material?

I noted that I missing some Batches in my Output although there is available QTY.

Can you please take a look on attached Output? You see the first line is already negative but we have 91 EA from the first Batch available and we only 40 EA of it. Please see below current formula...

IF [RunTot_Unrestricted] < [QTY to return to Memphis (rounded)]
THEN [Unrestricted]
ELSEIF [RunTot_Unrestricted] >= [QTY to return to Memphis (rounded)]
THEN [QTY to return to Memphis (rounded)] - [Row-1:RunTot_Unrestricted]
ELSE 0
ENDIF

Need this strategy in place

				needed output
	Material	Batch	return QTY (Material level)	Final QTY to return (Batch level)
1	7548	5	6	5
7548	4	6	1
2	7421	5	4	4
7421	4	4	0
3	8451	1	1	1
8451	1	1	0

Thank you for you help,

Pascal

Book2.xlsx

DavidP

Are you grouping on [Material] in the multi-row formula?

If not, it is possible that a value for a previous material is subtracted in the first line for this material - grouping by [Material] will prevent this.

Incidentally, 

IF [RunTot_Unrestricted] < [QTY to return to Memphis (rounded)]
THEN [Unrestricted]
ELSE [QTY to return to Memphis (rounded)] - [Row-1:RunTot_Unrestricted]
ENDIF

will yield the same results as your original formula since the condition in the ELSEIF is the exact opposite of the condition in the 1st IF