Jump to content

include zero in calculation


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

Recommended Posts

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
Link to comment
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
Link to comment
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
Link to comment
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.

Link to comment
Share on other sites

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.