Forum Discussion

Qrew Trainee

4 years ago

Checkbox formula when two summary fields equal each other

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 ta...

Formulas and functions

Relationships

MarkShnier__You

Qrew Legend

4 years ago

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
Qrew Trainee
4 years ago
Hi,

This is a checkbox formula.

Both fields are numeric field.

------------------------------
Sandralee Oster
------------------------------
- SandraleeOster
  Qrew Trainee
  4 years ago
  Oh my gosh! I feel stupid! I was using the wrong field for my formula.
  
  ------------------------------
  Sandralee Oster
  ------------------------------