Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You might try using a if statement
if(isnull(rank(...)),0,rank(...))
Regards.
would i need to use that in the definition of the example or in the min or max area of the gauge?
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.
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?
No. I misunderstood you.
Just try the following then:
if(isnull(SUM(expression value)),0,SUM(expression value))
Regards.
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
Please post the min and max expression of the gauge and the main expression to get a better idea or what is going on.