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

[DavidP · Accepted solution]

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

[Pascal_R]

Hi DavidP 

I just saw it this morning that I didn't  group by Material.

But thank you for Explanation on it.

Regards,

Pascal