Hi everyone, is it possible to do a % change by ye...
# generald
Derek E
03/15/2024, 4:16 PMHi everyone, is it possible to do a % change by year in a saved search formula?
I get the ERROR: Possible Divide by Zero error on my final formula:
Is this possible via Saved search?
Derek E
03/15/2024, 4:17 PM((CASE WHEN TO_CHAR({transaction.trandate}, 'YYYY') = '2023' THEN {transaction.amount} ELSE 0 END ) - (CASE WHEN TO_CHAR({transaction.trandate}, 'YYYY') = '2024' THEN {transaction.amount} ELSE 0 END) ) / CASE WHEN TO_CHAR({transaction.trandate}, 'YYYY') = '2023' THEN {transaction.amount} ELSE 0 END
Derek E
03/15/2024, 4:17 PMIf I change the "ELSE 0" to "ELSE 1" I get the "Unexpected error has occurred" screen
t
Tim Chapman
03/15/2024, 4:31 PMYou can't divide by a possible value of 0
d
Derek E
03/15/2024, 4:32 PMThanks tim, if I replace the end of the denominator statement with ELSE 1 I get the unexpected error has occured screen
m
Marc
03/15/2024, 4:33 PM((CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2023' THEN {amount} ELSE 0 END) - (CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2024' THEN {amount} ELSE 0 END)) / NULLIF((CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2023' THEN {amount} ELSE 0 END), 0)
t
Tim Chapman
03/15/2024, 4:34 PMIf that doesn't work then
(CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2023' THEN {amount} ELSE 0 END - CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2024' THEN {amount} ELSE 0 END) / NULLIF(CASE WHEN TO_CHAR({trandate}, 'YYYY') = '2023' THEN {amount} ELSE 0 END, 0)s
sam1128
03/15/2024, 4:47 PMd
Derek E
03/15/2024, 8:26 PMthanks for your help everyone!
2 Views