var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Want to get results without decimal places
The underlying table for my fact contains a Sale field whose data type is decimal.
In the cube editor, I have tried a few options (both for Data Type and Display format) but in my front-end I am still getting the results with 2 decimal places.
Can someone kindly help me how I can get the results in a rounded form so that the decimal places are not shown e.g. instead of seeing 12,345,678.98 I want the results rounded as 12,345,679.
If (and i really hope not) it boils down to using MDX in the front end then can u kindly guide me since I can only spell MDX at the moment
Many thanks in advance for your help.
round it when populating fact table
with data type currency and display format #,# it works fine
Tried that but does not work and that's why I posted this request
Originally Posted by rafala
Formatting is within the scope of the front-end and should be handles there. What interface are you using?