Goal : See shipped rev between a specific date range YOY. I would like to take this formula and create several columns using it but change the dates to reflect specific time period.
Example
1Half 2023 | 2Half 2023 | 1Half 2024 | 2H 2024
Field: Formula Numberic
Summary Type: Sum
formula : CASE WHEN {trandate}, BETWEEN TO_DATE('01/01/2023','mm/dd/yyyy') AND LAST_DAY('06/30/2023','mm/dd/yyyy') THEN {totalamount} ELSE 0 END
error: ERROR: Invalid Expression