Composite column showing books read over the years in the tags browser

[fracas]

I'm trying to set up a new column built from other columns (shown in tags browser) that returns the year I finished reading a book. This column must check that the "#complete" column is 100% and must transform the end-of-read date in the "#read" column (e.g., 11 nov 2025) to just the year (2025). However, for books with no end-of-read date but 100% read, it should return a text like: "Read in paperback or on another eReader."

The result I'd like in tags browser is something like this:

Books read ... 100
... ... 2022 ... . 50
... ... 2023 ... . 20
... ... 2024 ... . 15
... ... 2025 ... . 15

Can you help me?
Thanks.

I'm Italian, sorry for my English.

[Lys]

The code should be something like this:

program:

if $#complete  == '100' then
    if $#read == '' then "Read in paperback or on another eReader."
else 
    format_date(raw_field('#read'), 'yyyy')
fi
fi

Where if custom column "complete" is 100, you are evaluating read column, and if read column is blank, it returns the text, otherwise it returns the year.

[fracas]

Thanks a million, Lys!
It works, that's exactly what I wanted.
(I just changed '100' to '100%'.)
Thanks again.