Forum Discussion

Afilingeri's avatar
Afilingeri
New Member
9 years ago
Solved

Data not populated properly

Hi BI community. As a new user to the product, I am continuously getting stuck on basic issues that I am certain can be easily solved with your help. My current frustration is trying to figure out wh...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Afilingeri

     

    Plases Follow this steps:

     

    1.Change the Data type of this columns to Number

     

    2.Select SUM

Vvelarde's avatar
Vvelarde
Icon for Community Champion rankCommunity Champion
9 years ago

Afilingeri

 

The reason to your problem is your fields are not numbers.

 

You should delete the first row and let only numbers in the field.

 

You can delete in Edit Query. Remove Rows.

 

Regards

 

Victor

Lima  Peru

Afilingeri's avatar
Afilingeri
New Member
9 years ago

Hi Victor,

 

Thanks so much for the response. I took your advice and deleted first row so that rows one and two begin with numbers. See the updated sceenshot below. It does not appear the process worked... where am I going wrong? Again, really appreciate the help.

 

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity Champion
    9 years ago

    Afilingeri

     

    Plases Follow this steps:

     

    1.Change the Data type of this columns to Number

     

    2.Select SUM

    • Afilingeri's avatar
      Afilingeri
      New Member
      9 years ago

      Perfect! That was exactly what I needed. Thank you so much.