values getting rounded automatically

[CNC_reporting]

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 

[rajulshah]

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]

Thanks for your swift reply!

Unfortunatelly, it works with the sum only 😕

[rajulshah]

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

[CNC_reporting]

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

[rajulshah]

So what do you want rounded values for? It would be better if you could provide the sample file. @CNC_reporting 

[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

[Anonymous]

@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