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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIf 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
------------------------------
- MarkShnier__You
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.
