I am using calculations to show costs for a specific month and currency (Month 1 & Month 2, derived from two month parameters). I also have a Growth/Decline column (calculated percentage difference between the two month data calculations). I want to not show the rows where these calculated columns are zero or null. When I attempt this with an expression filter e.g. GROWTH/DECLINE != 0 I get the error:

Invalid Expression. Validation of parameter default values failed. A general error has occurred. Message returned from OBIS [ecid:2fd06818-558c-437e-aaf8-c4f54708bb89-00121250,0:5:1:6 ts:2026-01-26T15:12:59.371+00:00]. Query Failed: Function NativeExtractDateTime is called with an incompatible type. (HY000)

The cost calculations do include EXTRACTMONTH() from a parameter which could be causing the issue? however the calculations work perfectly so it must be a limitation with the Expression Filter.

I just want to filter out rows which are null or zeros and it currently feels impossible! Any guidance would be great, thank you.