2 Replies Latest reply on Nov 11, 2013 7:30 AM by WayneMORRELL

    Filemaker pro 10 question

    WayneMORRELL

      Title

      Filemaker pro 10 question

      Post

           Hi, probably another stupid question from a newbie.

           I have a company with a loyalty system, so every 6th visit you get free service...nice...

           So I have a field counting the visits, so Client Count equals Count(Event:Name).

           Now what Im thinking is just to divide the count by 6, if the result is a whole number then YES (Its a free service visit) if the result is not a whole number then NO (sorry your picking up the bill for this visit).

           Ive lost a couple of hours trying to figure this with the number functions but can't get it.

           Im sure you guys will figure this instantly, Id appreciate your help

            

           Regards

            

           Wayne from Oz