Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Number formatting in cube/crosstab
Migrateduser
<p>Hi,</p>
<p> </p>
<p>I have written the following expression in cube summary field</p>
<pre class="_prettyXprint">
Formatter.format(dataSetRow["Budget"],"$#,###.00")</pre>
<p>However, when I run the report, I get an error that cannot convert $2,000 to double. When I try to remove the $ from the format and then run the report, I do not see the thousand seperator comma and the decimal point. I simply see 2000 and so on in the measure</p>
<p> </p>
<p>Can someone please tell me how to format numbers and dates in cubes/crosstabs</p>
<p> </p>
<p>Arif</p>
Find more posts tagged with
Comments
There are no comments yet