Forum Discussion

BrunoFerres's avatar
BrunoFerres
Regular Visitor
8 years ago
Solved

Decimal places getting rounded in presentation view

Hi everyone! I'm with a serious problem. I want to show in my report numbers with 6 decimal places. When editting queries and preparing data, the values are ok, like 0.891344 but in the presenta...
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    I'm wondering if the Query Editor is causing the problem.  Can you please remove any formatting on that column in the Query Editor and make sure it is using the Decimal Number (and not Fixed Decimal number) up in the Query Editor.

     

    This sounds like something I've helped with before, but I can't find the resolution.  

  • BrunoFerres's avatar
    BrunoFerres
    8 years ago

    Now it worked!

     

    Beyond remove any formatting, I had to put a "CONVERT(DECIMAL(28,10)," in the native query source - although the column type is already that - and rebuild totally the query from zero in Query Editor, removing any transformation in the column.

     

    Thank You Phil_Seamark!

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI BrunoFerres

 

Do you mean using this formatting option when you say you raise the decimal places?

 

 

 

BrunoFerres's avatar
BrunoFerres
Regular Visitor
8 years ago

Hi Phil_Seamark

 

Yes, when i use the formatting, is added zeros, but not values.

Here is some examples:

 

 

 

 

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    Are you using a Decimal data type, or Fixed decimal (like currency?)

    • BrunoFerres's avatar
      BrunoFerres
      Regular Visitor
      8 years ago

      Decimal type.

      I also tried fixed decimal, but didn't work too.

      • Phil_Seamark's avatar
        Phil_Seamark
        Icon for Microsoft Employee rankMicrosoft Employee
        8 years ago

        I'm wondering if the Query Editor is causing the problem.  Can you please remove any formatting on that column in the Query Editor and make sure it is using the Decimal Number (and not Fixed Decimal number) up in the Query Editor.

         

        This sounds like something I've helped with before, but I can't find the resolution.