Chart with null row

[#1]

@ ! !Hello everyone,

I am creating a chart table (pivot table) but there is a row with a null value I dont know why.

If I dont upload any data it gives me this result:

And if I do (load data) this line keep there:

I guess the problem is in the creating of chart I not in the script.
My dimensions are Day and Volume. Because of this simple problem when I make another column to just add 50 to free (the column Free+50) it gives null in every row.

Do you have any ideas? Or any guesses where the problem is?

PS. On my fields there arent no null fields (that's why I think the problem is on the setup of the chart and not in the script to load the data).

[avinashelite]

Go to >expression> select > total mode>NO  total

this will eliminate the top null value

[jonasheisterkam]

Can you Upload a sample file? Coud it be the Total row(), have you deactivate Total on the expressions?

[avinashelite]

[#5]

Thanks for the help, I could remove the header, however the column which just adds 50 to Free still doesnt work and gives me nulls, any ideas?

[#6]

Yes, I think it was that. But do you know why the columns where I just add 50 to the last column it gives me nulls as the picture above shows? The first line is removed, but I cant calculate the sum of Free+50 on the expression of the last column it still gives nulls numbers.

[avinashelite]

can please share the expression or app ?/ so that we can check

[#8]

The expression is simple:

=Free+50

[avinashelite]

we can cannot guess the issue by this :

please post the app

[jonasheisterkam]

In Youre case Free might be a Text or have you define that it be written on the left side.