Truncate

[Kenneth Brody]

On 12/11/2013 4:54 PM, Matt Sherrill wrote:
> According the the filepro manual MOD() divides the number by 100 and
> then returns the remainder.

Correct.

> So mod("46949.500","100") ... 469.495 ... returns the remainder: 495

No, "495" is not the remainder.

     46949.500
     ---------  ==  469 with a remainder of 49.5
        100

By your description, what would you say is MOD("35","2")?  Or, better yet, 
MOD("35","3")?

> I've been e-mailing Ken White and am sending you what I sent him...
[...]

-- 
Kenneth Brody