include zero in calculation

[sal88]

Hi how do you include a zero in calculation fields? eg. 0.4 displays as .4

TIA

[Lee Smith]

The calculation function strips leading and trailing zeros. You can make it display the leading zero, if you format your number field as

[Lee Smith]

The Forum cut my post short. (?)

The whole post continues on to say

The calculation function strips leading and trailing zeros. You can make it display the leading zero, if you format your number field as currency, and remove the currency. Note the circle areas. Other than the 2 places, which you might have more or less selected.

HTH

Lee

Edited September 28, 2007 by Guest

[sal88]

thanks but the problem is (which i should have stated) that the calculation field also contains text

[Lee Smith]

That is a whole different situation.

Can you give an example of how this data in the text field looks (i.e. the text and numbers combined)?

And the Calculation.

Copy and paste here.

Lee

Edited September 28, 2007 by Guest

[sal88]

yeah its basically:

[number field] & " text here"

[Lee Smith]

If the number is entered as 0.4 in the number field, 8.5 will keep that format as is, when used in a calculation as you have shown. I don't see the problem here, unless the 0.4 was the result of a second calculation?

Lee

Edited September 28, 2007 by Guest

[sal88]

yes it was the result of a second calculation, sorry its friday im barely awake!

[comment]

This can be simple or difficult - depending on the expected results of your calculation (positive/negative/zero, needs rounding or not). The simplest method is to use a merged field in a text object, instead of a calculation. This can be formatted just a like a field.

[sal88]

i suppose the more difficult method is to have an if operator whereby if the left most digit is a period then it will at a zero to the start?

[comment]

But that would break with a negative fraction, e.g. "-.25". By difficult, I meant something like this:

http://www.fmforums.com/forum/showpost.php?post/152886/