Skip to main content
Question

Checkbox formula when two summary fields equal each other

  • September 9, 2021
  • 0 replies
  • 33 views

Forum|alt.badge.img+5
Hi,

I am getting the operator '=' can't be applied on type bools with this formula:  

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. 
Can I get some help with this?
Thanks!

------------------------------
Sandralee Oster
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------