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

AudraMickles's avatar
AudraMickles
Qrew Trainee
6 days ago

So, i tried that before and it hadn't worked, but when I tried it again this time, doubled checked the spelling on everything and figured out that whoever entered the original list of Types had 2 hanging spaces after the C type.  sigh  so it works!  yay!  but man, what a pain to figure out :/