Unexpected Error on data

[#1]

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.

[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