Result of sum is Null in advanced Search

[#1]

Hello everyody

I need to make an advanced search inordet to configure an alert.

The definition of the search is te following:

I want to show only the TIENDAS (stores) that belong to the GRUPO_COMERCIO = Grupo 1 and not have sells (TOT_COMISION_COMPARTIDA) Yesterday.

And I have the following expression in order to have the yesterday's sales:

=sum( {$<[GRUPO_COMERCIO]={'GRUPO 1'},FECHA = {">=$(=Date(today(1)-1))"},AñoD= ,TrimestreD= ,MesD= ,QuincenaD= ,SemanaDim= ,SemanaD= >} TOT_COMISION_COMPARTIDA)=

When I put this expression in the advance search of the fiel TIENDA, telling the sum = 0

=sum( {$<[GRUPO_COMERCIO]={'GRUPO 1'},FECHA = {">=$(=Date(today(1)-1))"},AñoD= ,TrimestreD= ,MesD= ,QuincenaD= ,SemanaDim= ,SemanaD= >} TOT_COMISION_COMPARTIDA)=0

The result is nothig (I suppose becasue for these stores there are no transacciotns to sum). But when I change the = 0 for >0, the result show me the stores that have sales yestarday.

How Can I seach for the stores that not have sells yesterday.

Thanks in advance for your help

[sunny_talwar]

What if you do <1?

[#3]

Same result than =0

[sunny_talwar]

So can you create a table with TIENDAS as your dimension and Sum({$<[GRUPO_COMERCIO]={'GRUPO 1'},FECHA = {">=$(=Date(today(1)-1))"},AñoD= ,TrimestreD= ,MesD= ,QuincenaD= ,SemanaDim= ,SemanaD= >} TOT_COMISION_COMPARTIDA) as your expression.

Do you see any 0?

[#5]

Not All is colpased

[#6]

Sorry Only shows values grater tan 0

[sunny_talwar]

Can you uncheck suppress when null on the presentation tab please and repost the image?

[#8]

The table remains the same

[sunny_talwar]

So I think the way the data is structured, the TIENDAS you are looking for, are actually nulls.

Would you agree that Total TIENDAS - (minus) TIENDAS you get when > 0 will give you what you are looking for??

[#10]

Yes thats exactly what I need