4 Replies Latest reply: Jan 10, 2013 4:04 AM by brdumeny RSS

    IsNull on Dimension and Expression

      Hello,

       

      I've got some troubles with isNull() function.

      IsNull() doesn't return the same values when I use it in expressions or dimensions in chart table.

       

      Here is my test :

       

      Dimensions :

      Dim1 :  =Null()               => Result :  ***

      Dim2 : =IsNull(Null())      => Result :  -1

      Dim3 : =IsNull([Name])   => Result :  ***  when name is null or  0 when name is not null

       

      Expression :

      Exp1 : =IsNull([Name])   => Result :  -1  when name is null or  0 when name is not null

       

      Presentation parameters of the chart table are :

      Null symbol : "***"

      Missing Symbol : "-"

       

      Result looks like this :

      NAME      DIM1      DIM2      DIM3     EXPR1

      Robin        ***          -1             0           0

      Martin       ***          -1             0           0

      ***            ***          -1            ***          -1

      ***            ***          -1            ***          -1

      John         ***          -1             0           0

       

       

      So, I've 3 questions :

      - I observe it with QV10 SR5, and I've never had this trouble with SR3. Has anything changed?

      - In dimensions : Why IsNull(null()) works and not IsNull([Name])?

      - Why IsNull([Name]) works differently in expression and in dimension?

       

      Thanks.