Mode function not working

[j_nlucas]

Hi,

I need to calculate the MODE of the result of the following expression: 

if(MaxString(_CodTipoSeleccion) = 'EF',
((Sum({<_KeyFecha={'>=$(v_FechaInicioSK)<=$(v_FechaFinSK)'},Año,Fecha,Día,DiaMes,Semana,Mes,MesNum,nMes,Trimestre, FchDocumentoVenta= >}MargenBruto) - Sum({<_KeyFecha={'>=$(v_FechaInicioSK)<=$(v_FechaFinSK)'},Año,Fecha,Día,DiaMes,Semana,Mes,MesNum,nMes,Trimestre, FchDocumentoVenta= >}ImpGastos)) / (Sum({<_KeyFecha={'>=$(v_FechaInicioSK)<=$(v_FechaFinSK)'},Año,Fecha,Día,DiaMes,Semana,Mes,MesNum,nMes,Trimestre, FchDocumentoVenta= >}ImporteVenta)- Sum({<_KeyFecha={'>=$(v_FechaInicioSK)<=$(v_FechaFinSK)'},Año,Fecha,Día,DiaMes,Semana,Mes,MesNum,nMes,Trimestre, FchDocumentoVenta= >}ImpGastos)))
,
((Sum(MargenBruto)- sum(ImpGastos)) / (Sum(ImporteVenta)-sum(ImpGastos)))
)

I wrapped all that into a variable that I've used in the Mode function but I keep getting nulls. 

I'm using it in a straight table with three dimensions. 

Any idea? 

Thank you

[jfkinspari]

Perhaps you have included a "=" and are calculating the variable before it's input into the straight table

[j_nlucas]

Hi Jfkinspari, no equal included. 

[jfkinspari]

Do you get a result if you use any other aggregation function, e.g. count?

[j_nlucas]

No I don't

[jfkinspari]

Okay, then I suggest you backtrack the problem, by moving the expression from the variable into the table itself, and find out when it starts to fails

[j_nlucas]

The expression works well with and without the variable in the table.

The problem arises when I apply an aggregation function to it. I am not sure I to backtrack that from there... 

[j_nlucas]

I have now reduced the expression to this:

Mode(Sum(MargenBruto))

and it's still returning null values

[jfkinspari · Accepted solution]

try using RangeMode(Sum(MargenBruto))

[j_nlucas]

That works!!

Thank you so much for your help. It's really appreciated!