views:

1617

answers:

2

I have some fields I currently populate with a P0. The results is like this:

     2,434%

I want however something like this:

     2434%

How do I do this?

A: 
      ####%

Note: Unfortunately, this does not lock down to a max of 4 characters (like I would expect/wanted), but it's close enough.

Jeff
+1  A: 

Have you tried something like 0000%? Or alternatively, an expression like:

=right(format(Fields!YourField.Value,"#%"),5).

I don't have BI studio open right now so I can't test these. The expression would of course convert the value to text, which maybe problematic when you export the report to excel.

Peter