Change format numeric columns in webi

[#1]

Hi Collagues!

I want to create a new format in webi, since the user has asked me that all the numerical columns of the reports have to be shown with a maximum of 6 decimal places, but only in the case that the decimal places is a number other than 0. If it is zero, it should not be shown. How could you create this format?

Example 1:

Number stored in the DB : 11.287,378400

Number to show in the report : 11.287,3784

Example 2:

Number stored in the DB : 11.287,3784310

Number to show in the report : 11.287,378431

BR,

Patricia.

[MichaelGrackin]

Apply a Positive custom format to the column containing the values: #.######

1 Pound -- #

1 decimal -- .

6 Pounds -- # # # # # #

[pamarque]

Hi Michael!

That format is the one I have set, but when the last decimals are 0, it continues to show me, and I need it not to show me the 0. It should only show 6 decimals when the decimals are numbers other than 0. Any ideas?

BR,

Patricia.

[MichaelGrackin]

I tested the format with both a Dimension and a Measure. It seems to work with both in Webi. Not sure why it is not working for you. We are using BOB42, SP7, Patch 13.

In the following image I used the eFashion universe to test it. I divided the SKU Number and the Sales Revenue by 1000000 to get the columns to the right of each with 6 decimal digits.