How can I dynamically count a column in OTBI?

Summary:

Hi,

In OTBI, how will I be able to get the count dynamically per year when the data type is string, and the sample value is "ABC 2024".

Here is my theory but it is not accepted because the data type is STRING.

COUNT(CASE WHEN table.column_name = 'ABC || TO_CHAR(CURRENT_DATE,'YYYY')'
THEN 1 END)

My desired output is to count the row having the data of "ABC current_year"

Version (include the version you are using, if applicable):

OTBI-24B