Variable not passed correctly to sql query


What am I doing wrong here. The "Andel aktiva, ej uppdaterade senaste X dagarna" question doesn't accept the variable.

I have the same variable in both the filter and the sql. Am I missing something?

Passing the Enhet-variable works fine.

Cheers / Erik

Hmm, If I try to filter on text instead, then I can chose it for the filter

But I have declared the variable in the sql as number
Skärmavbild 2023-10-26 kl. 14.12.29

Text filters only work with text variables. Number filters only work with number variables