Avoid Round off in float values

Who is online?  0 guests and 0 members
Home  »  Forums   »  microsoft business intelligence   »  analysis services   » Avoid Round off in float values

Avoid Round off in float values

Topic RSS Feed

Posts under the topic: Avoid Round off in float values

Posted: 5/4/2012

Jedi Youngling 60  points  Jedi Youngling
  • Joined on: 3/31/2011
  • Posts: 20

Hi,

In my DWH I have a data like below,

 

Now I want to show the data in PPS reports(Grid Report) I've to show 3 digits from decimal point,But that data can not be round off.It shows exact value.

Can you please tell me what is the best approuch to satisfy the above scenario.

In put  of Cube :                             

Yearly_Budget 
16.9884
16.9884
53.95404
NULL
NULL
39.02081
39.02081
0
78.23545
8.69058

0.18638

Yearly_Budget
16.988
16.988
53.954
NULL
NULL
39.02
39.02
0
78.235
8.69
0.186

Posted: 5/7/2012

Jedi Knight 1516  points  Jedi Knight
  • Joined on: 1/3/2010
  • Posts: 266

Where do you want to format your value, in cube or reporting?

If in cube you can use FORMAT_STRING='##.##'. Take a look.

If you are trying to format in reporting, than you can either try format cell in properties, or you can do it by coding FORMAT(value, "##,##")


Page 1 of 1 (2 items)