EXPRESSION and FILTER PROBLEM

[#1]

Hi Everyone !
My and my partner have a very urgent problem.

We have the next expression:

=if(Count(distinct MARCA = 1,

if(sum(Techo) > 0 and sum(Piso) = 0,

count({$<Cliente.NODO = {"=(sum({<Cliente.Nodo>} Compro_CAJAS) / sum({<Cliente.Nodo>} Techo) ) < 1"} > } Techo)

,'-')

With some dimensions:
MES, LIQUIDACION...

If we do FILTER data for any field of the PRODUCTOS table, like MARCA p.e. the expression works great,
But if we do not use filters the expression does not work !!!!

Any idea??

We will be unemployed soon if we do not solve this problem !!!!

Thanks in advance to everyone !!!

[Gysbert_Wassenaar]

It's amazing it works at all. There are at least two syntax errors in that expression. The parentheses don't match up. Can you post an example document that demonstrates the problem? Read this document: Preparing examples for Upload - Reduction and Data Scrambling

[#3]

My falt, I mis the last parentheses..
I am attaching an example with only one expression. This expression has several parts that are all the same, so I coment them to make it easier.

Note that the expresion result is different if you filter by Cod_Accion for example, than if you do not filter. The result I need is the one with the filter.

[#4]

The problem is set analysis. When he took the selection works. You have to review the syntax.

[#5]

I am sorry Giancarlo, what do you want to mean?

Sintax here? editor understand and does not say there is an error on it.

count({$<Cliente.NODO = {"=(sum({<Cliente.Nodo>} Compro_CAJAS) / sum({<Cliente.Nodo>} Techo) ) < 1"} > } Techo)