Posted: 5/4/2012
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 :
0.18638
Posted: 5/7/2012
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, "##,##")