have a transaction saved search that's acting VERY bizarre. Three summarized Formula (Currency) columns return "ERROR: Invalid Expression" randomly, for multiple users, or it will actually work. it's working as expected now...here's an example of one of the formulas
CASE WHEN {customitemdatefield} BETWEEN '7/1/2017' AND '6/30/2018' THEN {amount} ELSE 0 END
The item date field is a formula that derives a date value based on other item fields.