displaying % in value

Hi

I am calculating percentage using expression. I want to display % at the end of the result.

If I use P1 or P0 somehow it multiplies the result with 100 I guess.

Here is what my calculated value is

15.384515

and I want to display 15.38%

Using P1 or P0 I am getting 1,538.5%

How can I get the desired result?

Any help would be appreciated.

Regards

Amit

Yeah I always thought that was funny the way RS handles formating %.

You can try dividing your value by 100 and them formating it. I think the percent format requires a number between 0 and 1

e.d =format((field.value)/100,"P0")

that should give you "15%"

|||

You are great Nialhannon.

Thanks for your help. Your solution helped.

Regards

Amit

|||

I remember those issues, and I ended up doing the /100 in the dataset (or Stored Procs)

|||

Hi niallhannon,

I also have a similar problem in formatiing the data after rendering to excel.

The Field value is a percentage.

If there isn't any value zeros are getting displayed.

So if i use a format expression #,# (not to display anything in the cell),the percentage field is getting disturbed and is not getting displyed with two decimal places.

Kindly help me out in this issue.Its a bit urgent.

Thanks in advance

Nalini