Forum Discussion

SandraleeOster's avatar
SandraleeOster
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's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew 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's avatar
    SandraleeOster
    Qrew Trainee
    4 years ago
    Hi,

    This is a checkbox formula.

    Both fields are numeric field.

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

      ------------------------------
      Sandralee Oster
      ------------------------------