Forum Discussion
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 ...
Thanks for your swift reply!
Unfortunatelly, it works with the sum only 😕
CNC_reporting, can you provide sample reporting file to help you further? I didn't understand your last reply.
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
So what do you want rounded values for? It would be better if you could provide the sample file. CNC_reporting
No! I dont want to round them at all! I want the maximal precision.
So I have a table and a measure that devides Revenue by Impressions and multiplies it by a 1000 - there should be 5,9999 on the second row but it returns 6 instead
Plan_Id Plan Campaign_Id Kampan Revenue Impressions 379 cnn_leaderboard-1_23879.2 1914 RTB_-max-tagy_NEW 9,51 1585 739 sky_billboard-bottom-1_23467.4 1914 RTB_-max-tagy_NEW 1954,566 325761 906 abc_mobile-rectangle-1_24369.14 1914 RTB_-max-tagy_NEW 1033,872 172312