Displaying Number as a percentage

[Inky Phil]

Hi

This has cropped up again and I couldn't get it to work before. Whilst it is not of any real importance I would appreciate it if someone could point out what I am doing wrong.

I have a calc field 'margin' that calculates the margin as a percentage. When I display this field I would like it to have a trailing '%' mark.

Let's assume this field contains 55.347654321 (which to me is fifty five point three four percent).

When I go to format number for the field and set it to display as decimal to 2 places with the percentage notation I get 5534.76 %

If I set it to display as decimal to 0 places It displays as 5534 %.

How do I get it to display as 55.34% as I would like without having to include the % as text on my layout?

TIA

Phil

[comment]

Phil, surely you know that 50% means half. Therefore:

0.5 = 50%

1 = 100%

55.3 = 5530%

This is not a question of display. Your calculation needs to be divided by hundred at the end.

[Lee Smith]

There is something wrong with your first answer. Your 55.34, s/b in raw from .5534. Are you dividing correctly?

Lee

[T.J.]

You might try this.

In your margin calulation field could you take your formula and divide it by 100?

((price - cost) / price) / 100

[Inky Phil]

Thank you gentlemen, I see what it is doing now

Phil

Edited February 13, 2006 by Guest