Forum Discussion

CNC_reporting's avatar
CNC_reporting
Frequent Visitor
6 years ago

values getting rounded automatically

Hi, I have a simple CPM measure that divides the 1st column with 2nd column and multiplies it by a 1000. So the third coulmn in 3rd row should be 6,9999 something and not 7,00 (so no rounding!) I ...
Need Help
rajulshah's avatar
rajulshah
Resident Rockstar
6 years ago

Hello CNC_reporting,

You can go to Visual > Format Pane (pane that has Paint Brush icon) > Field Formatting:

Enter value as '2'or '3' or maybe '5'. It will then show the decimal places.

Hope this helps. Please let me know if this didn't. 

  • CNC_reporting's avatar
    CNC_reporting
    Frequent Visitor
    6 years ago

    Thanks for your swift reply!

     

    Unfortunatelly, it works with the sum only 😕

     

     

     

    • rajulshah's avatar
      rajulshah
      Resident Rockstar
      6 years ago

      CNC_reporting, can you provide sample reporting file to help you further? I didn't understand your last reply.

      • CNC_reporting's avatar
        CNC_reporting
        Frequent Visitor
        6 years ago

        I have a measure that devides two coulmns but returns rounded results in the table: 7,0000 instead of 6,9999

         

        The only thing that does not get rounded is the sum at the bottom. Sorry for making that unclear