1 Reply Latest reply: Jul 3, 2014 4:04 PM by Eduardo Sommer RSS

    Unexpected Error on data

      I don't understand why the last column is created, and as you see the circled 16,909, i what supposed the split between the months

      shown.

       

      The data is loaded from excel.

      Image1.png

        • Re: Unexpected Error on data
          Eduardo Sommer

          Hi, Gil

           

          You probably have data with invalid dates. So when you calculate year, month, etc, the functions will return null values. Observe that the dimensions are null for this values. You can mark Suppress when Value is Null for the dimensions, but this may cause a wrong value for you, since some data will be omitted. Try to find the data that is causing the nulls in the dimensions.

           

          Eduardo