Calculated fields and turning rounding off

[David52]

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

[cheonsa]

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.

[GoodBoy]

Hello! You may also use the Round() function in your formula, For example:

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

Just set the 0 to other number based on your preferred decimal places.

[Barbara]

How about setting the localization of the calculated field to show as many decimals as you need?

Cheers,

Barbara

[Wikiwi]

@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

 

Formula

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

[David52]

Wow, nine (9) views ... no answers. Hmmmmmmmm