Column shows #VALUE using a SQL query

Hello SeaTablers,
I need your help. I created a table using a SQL query. It also works for two columns but one column shows #VALUE!

What circumstances can lead to this?

Thank you in advance


for more details

It is likely related to the formula. Do you use the cloud version?

Can you create a sample base to reproduce the problem and send me a share link via private message?

Thank you very much for your feedback.

yes, I use the cloud version.

I had also the suspicion that it was the formula. So something like “if I refer to the original table in which something else needs to be calculated, the data is not yet available at that point in time”.