Hello to all,
I'm trying to manipulate certain data coming from an import from a csv file (that I wanted to upload, but it's not allowed from the forum) with numerical values.
The operation that I want to do is the average of the columns but, when I select the values, I get div/0! error
I tried to format the columns as numbers, but nothing changes. If I try to do the sum of 2 values, this works correctly.
It has been few days that I'm trying to solve this problem.
Can someone help me please?
CSV look:
imported data and error:
Version of office: office365
I'm trying to manipulate certain data coming from an import from a csv file (that I wanted to upload, but it's not allowed from the forum) with numerical values.
The operation that I want to do is the average of the columns but, when I select the values, I get div/0! error
I tried to format the columns as numbers, but nothing changes. If I try to do the sum of 2 values, this works correctly.
It has been few days that I'm trying to solve this problem.
Can someone help me please?
CSV look:
imported data and error:
Version of office: office365