SUM(one) screwed up

rmsmeltz
Participant V

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 146
6 REPLIES 6

Steve
Participant V

Not at all clear what youโ€™re asking of us.

The formula above isnโ€™t working correctly, even though when the system checks, it says itโ€™s good. Iโ€™m guessing you didnโ€™t notice any errors in it?

The syntax looks fine.

Worth trying this new feature?

Well, thatโ€™s embarrassing. I saved and closed everything and opened it back up and it seems to be working fine now. Maybe it was my browser or internet connect #SpectrumSucks

Iโ€™ll be making more coffee, if anyone needs me.

Thats how IT is gonna works.

IT (IrriTating)

Top Labels in this Space