pivot table error with percentage.

[Anonymous]

I faced a problem when I change the format of number like the following picture

I need to view the number as 2.3 %, 4.7% for example.

not 232% or 475%

Regards,

[marcus_sommer]

It depends how you calculate and/or display your results - in your case you need only to divide your result through 100.

- Marcus

[arasantorule]

Hi,

Please can you check your expression for "unit Cost".

I think the expression you are using may be (A/B)*100 instead of (A/B).

Please let us know if otherwise.

Thanks.

[vikasmahajan]

right click chart -> select number ->select show in Percent(%) option and check.

HTH

Vikas

[Chanty4u · Accepted solution]

use the formula /100  or u can try    or go to number tab and select number and show in % .. u wil get the exact value

hope this helps u

Thanks

Suresh

[jagan]

HI,

Divide your expression by hundred so that you will get the required result.

Regards,

Jagan.