2 Replies Latest reply on Oct 5, 2018 10:32 AM by Tram Le-Nguyen

    How to identify null/multiple values in ATTR()

    Tram Le-Nguyen

      Hi,

       

      For some table calculations, i have to use the attr() function. When I view the data it comes up as:

      A
      null
      null
      null
      null
      1
      2
      3

      I want to make a table calculation similar to:

       

      IF ISNULL(ATTR(A))

      THEN "Null"

      ELSE A/2

      END

       

      However, ISNULL(ATTR(A)) is never evaluated as true. I found out that the null values aren't actually empty values, but multiple values.

       

      For my data set, this conditional expression works:

       

      IF ATTR(A) > 0

      THEN "Null"

      ELSE A/2

      END

       

      I'm wondering if there is a direct way to identify if ATTR(A) has multiple values, in the case where i'm not able to use ATTR(A) > 0.

       

      Thanks!