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?

Not at all clear what you’re asking of us.

:confused:

2 Likes

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.

:man_shrugging:

2 Likes

Worth trying this new feature?

2 Likes

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 :man_shrugging:

I’ll be making more coffee, if anyone needs me.

3 Likes

Thats how IT is gonna works.

IT (IrriTating)

3 Likes