Truncate is the term for dropping digits after the decimal. There is
a function in the configurator tools for this. Good Luck!
a function in the configurator tools for this. Good Luck!
--- 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]
--- 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]
>
--- 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]
--- 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]