6 Replies Latest reply on Jun 14, 2010 9:15 AM by mikesmith1949

    Assigning calculation

    mikesmith1949

      Title

      Assigning calculation

      Post

      Hi I'm new to Filemaker and have just created a database (healthscreening) I have created a section called 'risk factors' where there are several check box buttons. I want to be able to add up the check boxes to create a total score, eg if 5 check boxes are ticked that results in a score of 5 (ie each check box = 1) or if they are not ticked this results in a score of 0, similarily if 3 are ticked this is a score of 3.

       

      I can do it for one check box easily by using the "if is empty field" which assigns it a value of 1 when ticked. But how do I add up all the check boxes to give me a total, can't figure it out!!!

       

      I am using filemaker pro advanced 11.0v.1