Calculate Order In-Full total with Line Detail

[bfuller62]

Hello,

I'm trying to write some sort of formula to evaluate the shipped Qty vs the Order Qty by SO # and maintain the item levle details like the example below

SO #	ItemNumber	LineCount	OrderQty	ShipQty	In-Full?
SO-1	1	1	100	100	1
SO-1	2	1	200	200	1
SO-1	3	1	150		0
SO-1	4	1	75	75	1
SO-1	5	1	22	22	1
SO-1	6	1	65		0
SO-1	7	1	70	70	1
SO-1	8	1	6	6	1
SO-1	9	1	12	12	1
Total		9	700	485	0

Thanks!

[Anonymous]

hello can you please calirify more?
you want to compare countorder with qtyship ? and if = then 1 if not then 0?

[bfuller62]

Hi - sorry, the column headers got weird when I posted it... I'm looking to compare ShipQty and OrderQty.

I'm trying to create a measure that will show a 1 if either the order line or order total is shipped in full 

[Anonymous · Accepted solution]

something like this ?