I've been using Denys Smakovskyi method of set analysis to ignore/use specific selections & adding static ranges. The issue I'm having is when I'm trying to use multiple conditions, I'm appending using the "+" set_operator (perhaps you know a better way?)
This will run but ignores the second condition "[OrderStatus]" so returns the sum of all orders (regardless of OrderStatus) that were entered within the specified datetime range
Thanks for the suggestion (it executed successfully) but did not change the result.
I can change the OrderStatus to "99999" (no such status) and the results remain the same. It's like it's not reading it at all.
There is a function I dont understand and cannot find documentation on. In the original post it's referred to as "Set Analisys union with correct modified "1"" ie '['&$Field&']=',','))>*1 although the expression will not run without it so I left it in