I'm trying to find out if there's a way to calculate totals from options in a drop down menu.
I use filemaker to keep school attendence and I have a drop down menu with options for present, absent and tardy. I would really like to create fields that can calculate the total for each category.
I have tried messing around with the functions available on my own without any luck. I would appreciate any ideas or advice :)