Skip to Content
0

Webi 4.2 Sort Numbers - Problems with 0

Feb 20, 2017 at 11:01 AM

30

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Premyslaw Splawinski Feb 20, 2017 at 11:25 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0