2 Replies Latest reply on Apr 17, 2010 4:23 PM by StephenC

# Another Calc field question

### Title

Another Calc field question

### Post

Hello:

I am trying to work my way through the Filemaker Training series.

Have hit the wall with this one.

In Lesson 5.2 Number Functions there is a question number: 5.2.9

MOD = Returns the remainder when the number is divided by devisor

INT   = Returns only the interger portion of number

Mod (Int (Score) ; 10)

Where Score = 123.4567

so:  (123 (123.4567) ; 10)

OK, I have asked a couple of folks in my home what this means and no one seems to know. I looked at the answer and it is 3.

So can some one enlighten me on the procedure to get to the answer...please

Red

• ###### 1. Re: Another Calc field question

If Score = 123.4567, then Int ( Score ) = 123, and Mod ( Int ( Score ) ; 10 ) = Mod ( 123 ; 10 ).

123 divided by 10 is 12, with a remainder of 3.

• ###### 2. Re: Another Calc field question

lol...

Filemaker acana

I was mislead by the INT inside the brackets...

Thanks for the reply we had a good laugh at our lack of insight in to the formula..

all the best and thanks again..

Red