Sort fields with null values

[#1]

I tried to order with a dimension match function . I give you an example :

match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' )

This put it in -> Sort - Expression

But when one team has "0" placed me in the first position. I want Although the value is null, is it possible to continue to keep the order I put it , any suggestions?

Thank You !!

[jagan]

Hi,

Try this

match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ', '*' )

Regards,

Jagan.

[pokassov]

Hello!

if(match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' )>=1,match ( TEAM, 'Madrid' , 'Barcelona' , 'Sevilla ', ' Oviedo ' ),99)

[Joaquin_Lazaro]

Hello rrrrrrrr8:

Try this:

If (match( ...) = 0, 99, match( ...)

Saludos,

Joaquín

[#5 · Accepted solution]

SOLUTION:

Ordenar dimensión con campos nulos