Checkbox formula when two summary fields equal each other

Question

Hi,I am getting the operator '=' can't be applied on type bools with this formula:&nbsp;&nbsp;If([# of Medical Records]=[# of Medical records Received], true)I have a parent table and a child table. I want to have a checkbox that will be true when all records are received in the child's table.I created two different summary reports.&nbsp;Can I get some help with this?Thanks!------------------------------Sandralee Oster------------------------------

markshnier__you · Answer

That is strange, Can you tell us what field types each of those two fields in the formula are, as well as what field type the formula is in?

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

sandraleeoster · Answer

Hi,This is a checkbox formula.Both fields are numeric field.------------------------------Sandralee Oster------------------------------

sandraleeoster · Answer

Oh my gosh!&nbsp; I feel stupid!&nbsp; I was using the wrong field for my formula.------------------------------Sandralee Oster------------------------------

Forum Discussion

Checkbox formula when two summary fields equal each other

3 Replies