Skip to Content
0
Former Member
Dec 01, 2011 at 11:00 AM

Dashboard Xcelsius - How to make Currency dissapear

24 Views

Hia BO Pros,

I am currently creating a Dashboard based on a BEx Query.

In BEx Query, all the Currency are displaying accordingly in every cell.

For example:-

BEx Query
=========
Q1                 Q2               Q3              Q4
99.00MYR          45.00MYR      56.00MYR       78.00MYR
232.00MYR        23.00MYR      98.00MYR       29.00MYR

However, when I display the Query table by using Dashboard via 'Selector > Spreadsheet Table'.

The the table displayed with some of the cell with missing Currency, as below:-

Dashboard
=========
Q1                 Q2               Q3              Q4
99.00MYR     45.00MYR          56.00MYR             78
232         23.00MYR             98                29.00MYR

I have tried all sorts of way, but it still doesn't work.

Any help is much appreciated.

Many thanks