Unable to sum a beast mode formula
I'm trying to get the first and last days of the selected date range and return dollar amounts on those days. When I use the following formula I am able to sum the dollars CASE WHEN `InventoryDate` = '10/1/2022' THEN `dollarsOnHand` ELSE 0 END When I use the following formula I lose the ability to sum the column CASE WHEN…
