Forum Discussion

AudraMickles's avatar
AudraMickles
Qrew Trainee
7 days ago
Solved

Report Formula - Combine some, exclude some, and include others.

I have a field [Types].  there can be A, B, C, D, E, or F. I need a summary report about these [Types]  but the output needs to show, A, B, C+D, and exclude E and F.  I'm using filters to exclude E ...
formulas
  • Mez's avatar
    Mez
    6 days ago

    Is this report formula being used in a summary report? What if you use the Case() function instead? Does this produce the desired output?

    Case( [Type], "A", "A", "B", "B", "C", "G", "D", "G" )

Mez's avatar
Mez
Qrew Assistant Captain
6 days ago

Ah, yeah, those pesky leading or trailing spaces. When I get results that don't seem right and I'm building a formula, I will either switch to using length or trim to see if adding this around the field produces the desired result or not. If you have another report formula still available, then use that perform this check so you can still see both of these report formula columns.