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.
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)
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |