Integer Blank Title 73464

Truncate is the term for dropping digits after the decimal. There is
a function in the configurator tools for this. Good Luck!
Anyone know why Int(2.8) return 3!?

I'm creating an expression in Configurator using the Int formula and
Int is returning the wrong calculation.

Int is supposed to be Integer, not Round!

So, Int(2.8) is supposed to return 2.

Any help would be appreciated.
Integer values do not handle decimals and thus it will round up or down
depending on the value on the right side of the decimal - 2.8 will round up
to 3 and 2.3 will round down to 2.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
lovesgolfing18holes
Sent: Monday, January 26, 2009 6:09 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Integer

Anyone know why Int(2.8) return 3!?

I'm creating an expression in Configurator using the Int formula and
Int is returning the wrong calculation.

Int is supposed to be Integer, not Round!

So, Int(2.8) is supposed to return 2.

Any help would be appreciated.



[Non-text portions of this message have been removed]
You can convert the 'decimal' to a string , manipulate the string to get rid of the decimal point and anything after the decimal point, then convert the result back to an Integer.

--- On Mon, 1/26/09, Carl Peterson <cpeterson@...> wrote:

From: Carl Peterson <cpeterson@...>
Subject: RE: [Vantage] Integer
To: vantage@yahoogroups.com
Date: Monday, January 26, 2009, 7:29 PM






Integer values do not handle decimals and thus it will round up or down
depending on the value on the right side of the decimal - 2.8 will round up
to 3 and 2.3 will round down to 2.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
lovesgolfing18holes
Sent: Monday, January 26, 2009 6:09 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Integer

Anyone know why Int(2.8) return 3!?

I'm creating an expression in Configurator using the Int formula and
Int is returning the wrong calculation.

Int is supposed to be Integer, not Round!

So, Int(2.8) is supposed to return 2.

Any help would be appreciated.


[Non-text portions of this message have been removed]


















[Non-text portions of this message have been removed]
It seems like INT(x-.5) would give you what you want.



--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Integer values do not handle decimals and thus it will round up or
down
> depending on the value on the right side of the decimal - 2.8 will
round up
> to 3 and 2.3 will round down to 2.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> lovesgolfing18holes
> Sent: Monday, January 26, 2009 6:09 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Integer
>
> Anyone know why Int(2.8) return 3!?
>
> I'm creating an expression in Configurator using the Int formula
and
> Int is returning the wrong calculation.
>
> Int is supposed to be Integer, not Round!
>
> So, Int(2.8) is supposed to return 2.
>
> Any help would be appreciated.
>
>
>
> [Non-text portions of this message have been removed]
>
I've always run a check.... If INT(#) > # THEN INT(#) - 1 ELSE INT(#)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Bill Jackson
Sent: Tuesday, January 27, 2009 7:05 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Integer



You can convert the 'decimal' to a string , manipulate the string to get rid of the decimal point and anything after the decimal point, then convert the result back to an Integer.

--- On Mon, 1/26/09, Carl Peterson < cpeterson@nexussoft <mailto:cpeterson%40nexussoftware.net> ware.net> wrote:

From: Carl Peterson < cpeterson@nexussoft <mailto:cpeterson%40nexussoftware.net> ware.net>
Subject: RE: [Vantage] Integer
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Date: Monday, January 26, 2009, 7:29 PM

Integer values do not handle decimals and thus it will round up or down
depending on the value on the right side of the decimal - 2.8 will round up
to 3 and 2.3 will round down to 2.

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf Of
lovesgolfing18holes
Sent: Monday, January 26, 2009 6:09 PM
To: vantage@yahoogroups .com
Subject: [Vantage] Integer

Anyone know why Int(2.8) return 3!?

I'm creating an expression in Configurator using the Int formula and
Int is returning the wrong calculation.

Int is supposed to be Integer, not Round!

So, Int(2.8) is supposed to return 2.

Any help would be appreciated.

[Non-text portions of this message have been removed]

[Non-text portions of this message have been removed]







[Non-text portions of this message have been removed]
If you are wanting only the whole number part with no rounding, use
the trunc or truncate function.
I've never tried it, but are "FLOOR" and "CEILING" functions supported?
If they are, they should return the integer portion of the real number.

--Ari

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Mike Barnard
Sent: Tuesday, January 27, 2009 8:01 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Integer



If you are wanting only the whole number part with no rounding, use
the trunc or truncate function.






[Non-text portions of this message have been removed]
Don't see 'floor' or 'ceiling' , 'truncate' looks like the way to go : Truncate(yourDecimal, 0 )
Â
-certainly much easier than my soulution

--- On Tue, 1/27/09, Ari Footlik <ari@...> wrote:

From: Ari Footlik <ari@...>
Subject: RE: [Vantage] Re: Integer
To: vantage@yahoogroups.com
Date: Tuesday, January 27, 2009, 9:09 AM






I've never tried it, but are "FLOOR" and "CEILING" functions supported?
If they are, they should return the integer portion of the real number.

--Ari

____________ _________ _________ __

From: vantage@yahoogroups .com [mailto:vantage@yahoogroups .com] On Behalf
Of Mike Barnard
Sent: Tuesday, January 27, 2009 8:01 AM
To: vantage@yahoogroups .com
Subject: [Vantage] Re: Integer

If you are wanting only the whole number part with no rounding, use
the trunc or truncate function.

[Non-text portions of this message have been removed]


















[Non-text portions of this message have been removed]