cancel
Showing results for 
Search instead for 
Did you mean: 

Webi 4.2 Sort Numbers - Problems with 0

0 Kudos

Hello,

iam using the Webi Rich Client 4.2 SP6 and i got the following problem. If i try to sort numbers (it's not important if iam using Ascending or Descending), 0 is always on the first position.

Does anyone know, why this is so?

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

I found somethin new. If i got a Report where i got Reseller with Measures and there are some Resellers without a Measures, then i got a 0 in the Report but it is not a Number, so i think this is the Problem. Is there any Solution for this? How i can say the Report, if there i no Measure then show me 0 as Number.

amitrathi239
Active Contributor
0 Kudos

=if(isnull([measure])) then 0 else [measure]