Discussions

  • 1.  Checkbox formula when two summary fields equal each other

    Posted 09-09-2021 10:31
    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
    ------------------------------


  • 2.  RE: Checkbox formula when two summary fields equal each other

    Posted 09-09-2021 10:34
    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
    ------------------------------



  • 3.  RE: Checkbox formula when two summary fields equal each other

    Posted 09-09-2021 10:41
    Hi,

    This is a checkbox formula.

    Both fields are numeric field.

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



  • 4.  RE: Checkbox formula when two summary fields equal each other

    Posted 09-09-2021 10:43
    Oh my gosh!  I feel stupid!  I was using the wrong field for my formula.

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