AnsweredAssumed Answered

Filemaker pro 10 question

Question asked by WayneMORRELL on Nov 10, 2013
Latest reply on Nov 11, 2013 by 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

Outcomes