Jump to content
  • 0

Calculated fields and turning rounding off


David52
 Share

Question

Greetings.

Is there a way to stop calculated fields from rounding values?

For example, here's a line item I have for one of my calculated fields: :(

Abs([@field:fees]*.015)

The results round, and I'm trying to avoid this from happening. What would I need to add to this line item to prevent this from happening? Does anyone know of a few sample line item lines which remove rounding, add rounding to a specific range, etc.?

Thanks in advance,

Dave

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 2
On 7/22/2012 at 7:26 AM, David52 said:

Greetings.

Is there a way to stop calculated fields from rounding values?

For example, here's a line item I have for one of my calculated fields: :(

Abs([@field:fees]*.015)

The results round, and I'm trying to avoid this from happening. What would I need to add to this line item to prevent this from happening? Does anyone know of a few sample line item lines which remove rounding, add rounding to a specific range, etc.?

Thanks in advance,

Dave

 

I know it's too late to answer this post but for other users that may go over this, here's my take to this question:

Upon checking the formula, the result is not rounding off. Make sure that the formatting is set to none.

Screenshot_52_7.png

Link to comment
Share on other sites

  • 0

@David52 I tested this on my end and it seems that calculated values has a hard limit of 6 decimal points even if you set your formatting to "none". A work around would be to create or edit your field for your calculation and use a formula datatype instead. the downside of this would be your user wound not see the results until they submit their entry and.

Calculated value

image.png.2afc51b982329f9db707365960536eff.png

 

Formula

image.png.d8eba66f5122e09e83e3062ce2aea7e1.png

The formula I used for the form field is number2*number3

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...