Hello,

I have table with 3 columns: record_id (int), car (varchar(50)), amount (decimal(18,4)).

I created dimension for drillthrough action. Also I set Amount's column FormatString to '##0.00' but when I use Drillthough column Amount values is shown like:

.0000

15.7900

18.4100

Is there any possibility to change that values would be shown as follow:

0,00

15,7900

18,4100

• Edited by -VB- 20 hours 31 minutes ago

Maybe it isn't possible? Give any thoughts.

Maybe it isn't possible? Give any thoughts.

Where are you viewing this? in management studio or in client tools like Ms Excel pivot?

Hi VB,

According to your description, you want to format the numbers after drillthrough action. Right?

In Analysis Services, it's not supported to set format when defining drillthrough action, the numbers will using format string defined in dimensions/measures. So you can only reset the format in client tool. For example, Format Cells in Excel. Also you can consider using Report Action which can format data fields within a SSRS report.

Regards,