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 ...
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 |
CNC_reporting
The measure 6,000000 is correctly calculated for me with figures in the table, is it possible that the revenue and impressions are rounded, when it should had decimal numbers. Try change the columns and measures to decimals in the option:Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly