Solved: Trying to create a slice for my item's current loc... - Page 2

Neal_MF_Harper · 03-30-2019 06:45 PM

I have a table for scanning ITEMs and LOCATIONs with a TIMESTAMP.

I’m trying to create a slice that lists ITEMs with the most current TIMESTAMP and LOCATION, omitting the duplicates ITEMS in the table with older TIMESTAMPS.

I’ve danced around with MAX() and SELECTS() but the logic of making it work is escaping me.

Thanks for the help everyone!

Steve

Good for you for implementing Current Location! Without it, using the previously suggested SELECT() expressions would be pretty expensive.

Try this as your filter expression:

AND(
  ISNOTBLANK([Location Key]),
  ([Location Key] = [Merch ID].[Current Location])
)

The ISNOTBLANK() (and consequently AND()) is not required if [Location Key] is guaranteed to be non-blank.

View solution in original post

Trying to create a slice for my item's current location