Forum Discussion
values getting rounded automatically
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 
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