Forum Discussion

CarolMcconnell's avatar
CarolMcconnell
Qrew Captain
10 months ago

Report Formual Fiel

I'm trying to add a report formula and the formula is based on a multiple choice text field.

It's simple, I'm trying to just pull the ones where there is nothing in the closed reason field.

I can't seem to get it to work.  This seems like something I should know but I can't figure it out.

Thank you.



------------------------------
Carol Mcconnell
------------------------------

13 Replies

  • If its a simple filter, then you can just have a filer where closed reason "is equal to" and then just leave the box blank.

    If you actually have a more complex formula which you are unable to do with a simple report filter, then it's like a formula in a formula field and you would test for blank like

    [Closed Reason] ="" 



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • CarolMcconnell's avatar
      CarolMcconnell
      Qrew Captain

      Mark, I tried the easy [Closed Reason]="" but I get expecting text but found bool.



      ------------------------------
      Carol Mcconnell
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend

        If you just want to filter the report, do not use a report formula at all. Just use the report filter. 



        ------------------------------
        Mark Shnier (Your Quickbase Coach)
        mark.shnier@gmail.com
        ------------------------------