Is anyone playing around with the Inventory Snapshot subject area (or any of the snapshots)? I'm trying to do a custom calculation formula to grab inventory on hand for a series of specific dates, but my Case/When's aren't behaving and would like to share ideas.

I'm not but I don't mind taking a look at your statement to see if I could be of any help

I found the answer. Can't do it apparently. From https://support.oracle.com/knowledge/Oracle%20Cloud/3034594_1.html

Inventory Snapshot captures a daily snapshot of the items.

The results must include the date else the report will aggregation across all dates. Again, snapshots are daily records, so there will be multiple records across the dates if you just use a filter.

You must add a date column to the report or simply filter on a single date when querying NSAW snapshot subject areas.