Calculation Field Changes Font Widths

[Texarado]

I have created FMPro calculation fields that produce text results, but when I use spaces or dashes to position the text, their widths expand. This would be used as a simple chart in a summary part. Here is an example:

Case(Total Bonds % <= .020,"X",

Case(Total Bonds % <= 0.40,"_X",

Case(Total Bonds % <= 0.60,"__X",

Case(Total Bonds % <= 0.80,"___X",

Case(Total Bonds % <= 1.00,"____X","")))))

The calculated result changes the width of the spaces (or dashes) to be wider than the "X" character. As a result, my fields must be much wider than I want.

If I type these same text characters in layout mode, their spacing is perfect. Only when they are the result of a calculation do they change dimensions.

At first, I thought it was because I was using an "art" font like Digbats or Nelco Symbols. But when I tried a plain font like Arial, I got the same problem.

Has anyone else figured out how to overcome this problem? Thanks!

[Lee Smith]

Hi Texarado,

Maybe a merge field will do the trick for you, Go into Layout Mode, Menu, Insert, Merge (Cmd M) on a Mac.

HTH

Lee

[Ugo DI LUCA]

I've just run a test from what you were saying using a set of different fonts (Verdana, Arial, Helevetica,...) and it appears that :

Dashes ____X works perfectly (same result as layout mode) but spaces doesn't work with any font.

[Vaughan]

Is the result of the calculation defined as text or number?