Rank Problem

building reports desktopintelligence
1

Hello
I am doing a ranking on a Dimension and some times I get either negative values or 0. The places I get negative values I realized that the dimension I am ranking on does not have any data. The negative values of ranking I see are assigned to the highest values.

Dimension Value Ranking Value
Empty -3
138.11 -2
119.79 -1
105.73 0
75.82 1

What do I need to change to see all positive values and that the ranking starts at 1 and not 0 or negative.

Thanks

patty :india: (BOB member since 2004-02-12)

2

You can make a variable that filters out the negative or null numbers returning 0. Rank on this variable. Make sure it is a measure object.

Randy Jones :us: (BOB member since 2002-08-19)