SUM(one) screwed up

[rmsmeltz]

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?

[Steve]

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

[rmsmeltz]

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?

[Steve]

The syntax looks fine.

[Koichi_Tsuji]

Worth trying this new feature?

Expressions: New option for faster and more consistent comparisons Announcements

Hey everyone! In the coming days, we will enable the option for expressions in apps to use new behavior for comparison operators (=, <>, <, <=, >, >=). This will be an improvement in sync performance and consistency of results. The current behavior will be called the Legacy option and the new behavior will be called the Consistent option. The ability to change an app between Legacy and Consistent will be added under Data > Options > Expressions > Blank value comparison mode. [image] Performa…

[rmsmeltz]

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.

[Koichi_Tsuji]

Thats how IT is gonna works.

IT (IrriTating)