SUM(one) screwed up

I had this right, then I regenerated my columns with a new name for the column it was in, and it cleared it out.

SUM( SELECT( Scans[Total], AND( ([_THISROW].[WO#] = [Work_Order_Number]), ([_THISROW].[Shipment ID] = [Amazon_Shipment_ID]), ([_THISROW].[FNSKU_ASIN] = [FNSKU_ASIN]) ) ) )

I want the sum total of the items that match the FNSKU, Shipment ID, and Work Order. It was working and I had to go and screw it up. @MultiTech_Visions @Steve, maybe yโ€™all have an idea?

0 6 149
6 REPLIES 6
Top Labels in this Space