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 have tried ROUND to 4 digits and modelling but to no avail - it just corrects the sum (which is good but I need the values in rows unrounded as well)

 

Thank you 

 

Need Help

7 Replies

  • 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.