Skip to Content
Jan 26, 2021 at 07:55 PM

Filter on variable is empty

51 Views Last edit Jan 26, 2021 at 10:04 PM 2 rev

Dear Community,

last time I am trying to solve one issue.
Table was created few years ago and worked perftectly till last weeks.

On screenshot you can find the example of data set and I can't understand why I am not able to use filter (no data shown in list) on variable "variable_not_working" if the data is retrieved successfully (table cointains proper values)...

In that case the table is showing #ERROR... For example above the table it's used one command:

=Count([Customer Code]) Where (IsNull([dummy column]) And [Year Filter] = "Current Year" And [DC]="Dealer" And [variable_not_working] InList( "Indirect";"Indirect Broker" ))

INB4 - variable_not_working is simple Dimension.

Thanks in advance!


screenshot-bo.png (38.6 kB)