If Calculation

[tussing515]

I have a very basic calculation I'm using a report along with another line that totals how many times "AHCCCS" is clicked: Case( Visit Reason = "AHCCCS"; 1; 0)

This works well; however, there is a slight hiccup. If I click anything besides "AHCCCS" in Visit Reason it doesn't work. It doesn't count these in my total. So if I clicked "AHCCCS" twice and "AHCCCS" & "Ultrasound" once, I only get a 2 in my field instead of a 3.

 

Any suggestions?

[LaRetta]

Case( Visit Reason = "AHCCCS"; 1; 0)

 

I assume then that the field is comprised of checkbox for multiple entry?  If so, try:

 

not IsEmpty ( FilterValues ( yourCheckbox ; "AHCCCS" ) )

There is no need to use Case since a boolean test works just as well.

[tussing515]

You are correct. It is a multiple checkbox.

 

The field after this is a summary field with the total so it can count it. Would this count the number of times "AHCCCS" is checked? Would I still need the summary field?

 

I'm still new to FileMaker so I'm still trying to figure out what does what. Sorry for all the questions.

 

Edit:

I just plugged that in and kept the summary field and it worked! Thank you so much!