Truncate

[Bruce Easton]

I guess in two steps, where aa="46949.5":

Then:  rs(8,.0)=aa / "100"
Then:  fs(8,.0)=rs*"100"

Bruce



On 12/11/13 2:48 PM, Matt Sherrill wrote:
> Ken,
>       Thanks for your help - and sorry for taking so long to reply.
> Your solution of:
>
> Result = 46949.500 - mod("46949.500","100")
> Result = 46949.500 - 495
> Result = 46454.5
>
> ... doesn't seem to work - unless I don't understand how MOD works?
>
> Let me try to restate my problem.
>
> If I have a calculated number of 46949.5, I need it to round the nearest hundreds "after" dropping the decimal.
>
> So the steps would proceed like this:
> 1. 46,949.5 becomes 46,949
> 2. 46,949 rounds to the nearest hundreds to become 46,900
>
> Thanks for your help!
>
> Matt Sherrill
>
>
>
>> ________________________________
>> From: Kenneth Brody <kenbrody at spamcop.net>
>> To: Matt Sherrill <mmsv45 at yahoo.com>; "filepro-list at lists.celestial.com" <filepro-list at lists.celestial.com>
>> Sent: Tuesday, November 19, 2013 12:38 PM
>> Subject: Re: Truncate
>>
>>
>> On 11/19/2013 11:24 AM, Matt Sherrill wrote:
>>> I’m sure this has come up before, but how do
>>> you truncate the decimals without FilePro rounding the number?
>>>
>>> I have 46949.500 that I need to round to the
>>> hundredth place (without the decimals).  So I want my result to
>>> show "46,900", not "47,000" - which is what is happening now.
>> Do you want it "without rounding the number" or "round to the hundredth place"?
>>
>> Assuming you mean that you want to "truncate" (to the "hundreds", not
>> "hundredth"), as implied by your subject, so that "46999.999" becomes
>> "46900" (your example would have the same result whether "truncate" or "round"):
>>
>>       result = number - mod(number,"100")
>>
>> If this is not what you meant, please post a better description of what you
>>
>> need.
>>
>> -- 
>> Kenneth Brody
>>
>>
>>
>>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: http://mailman.celestial.com/pipermail/filepro-list/attachments/20131211/95314985/attachment.html
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list