# include zero in calculation

This topic is 6113 days old. Please don't post here. Open a new topic instead.

## Recommended Posts

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

TIA

##### Share on other sites

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

##### Share on other sites

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 by Guest
##### Share on other sites

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

##### Share on other sites

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 by Guest
##### Share on other sites

yeah its basically:

[number field] & " text here"

##### Share on other sites

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 by Guest
##### Share on other sites

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

##### Share on other sites

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.

##### Share on other sites

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?

##### Share on other sites

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/

##### Share on other sites

This topic is 6113 days old. Please don't post here. Open a new topic instead.

## Create an account

Register a new account