Ranking -- if nothing to rank show Blank

[#1]

hi ,

I am ranking products. When I choose certain filters -- there is nothing to rank -- in that case I see a garbled message ' bad min or max value in gauge'

how do i get rid of this and show something else?

thanks

[pover]

You might try using a if statement

if(isnull(rank(...)),0,rank(...))

Regards.

[#3]

would i need to use that in the definition of the example or in the min or max area of the gauge?

[pover]

Given the error message, I would say in the min or max area of the gauge becuase the range of those areas should never be null.

Regards.

[#5]

I have not used the rank function.

In the expression I am simply using the field value. and then in the gauge section I am using

SUM(expression value) for MAX. So I get little linear gauges with a staircase kinda effect.

In my case I suppose i do not need to use rank then?

[pover]

No. I misunderstood you.

Just try the following then:

if(isnull(SUM(expression value)),0,SUM(expression value))

Regards.

[#7]

The expression is right but it does not seem to work. As I am still getting the original 'error' when no values are there.

tia

[pover]

Please post the min and max expression of the gauge and the main expression to get a better idea or what is going on.