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

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

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

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

I don't want to filter the report. This is a summary report and I'm wanting to summarize the different closed status into columns. So I'm using the closed reason because I need to sum records in three different closed reasons and one of those are those without a closed reason. ------------------------------Carol Mcconnell------------------------------

If you just do a summary report where you have it based on all records in the table then group by the [Closed Reason] one of the groupings will be (empty) which is a blank Closed Reason. You could then look at those in a drilldown report.

Report Formual Fiel | Qrew Discussions

13 Replies

MarkShnier__You
Qrew Legend
12 months ago
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
  Qrew Captain
  12 months ago
  Mark, I tried the easy [Closed Reason]="" but I get expecting text but found bool.
  
  ------------------------------
  Carol Mcconnell
  ------------------------------
  - MarkShnier__You
    Qrew Legend
    12 months ago
    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
    ------------------------------

Forum Discussion

Report Formual Fiel