Forum Discussion

Claus_Thöle's avatar
Claus_Thöle
New Member
4 years ago

Fact column not summarizing

Hi,

this is my first message in this community. 🙂 I have built a model on a CSV file. This model contains several fact columns (sales revenue, discount..). I have also defined the column as facts (type: decimal, summarize: sum).

But when I use the column it is not summarizing.

 

The column is also not displayed in the model as a fact columns.

 

Here you can download the file.

What am I doing wrong?

Thanks in advance!

2 Replies

  • Adescrit's avatar
    Adescrit
    Impactful Individual
    4 years ago

    Hi Claus_Thöle ,

     

    If you try to create a measure to calculate the Sales Revenue, e.g. Sales Revenue = SUM( Sales Revenue ) is that displayed correctly in your table?

     

    The sigma sign being missing from the Sales Revenue column (not identifying it as a fact column) could indicate that there are non-numeric fields in the column such as blank/null values.

    • Claus_Thöle's avatar
      Claus_Thöle
      New Member
      4 years ago

      Hi Adescrit,

      thank you for you reply.

      When I create a measure like: Sales Rev = sum([Sales Revenue])

      Ii will work correctly.  I cant't find any blank or null Value. It also happend in every fact column.

      Regards