Forum Discussion

Qrew Cadet

2 years ago

How to mask % totals on summary line of report

This may be a very elementary question, but hoping the community can help. I have reports that need to have $ fields summarized but do not want to summarize % fields. How do I summarize some but ...

katlyncowley

Qrew Assistant Captain

Enter the field settings for your numeric field and make sure both "Display a total of this field in reports" and "Display and average of this fields in reports" are unchecked.

If you need it in some reports but not others, I think your best option is to create a formula text field or a report formula (if the type of report allows) and display it as opposed to your numeric field. ToText([numeric field]) would be the appropriate formula.

------------------------------
Katlyn Allen
kallen@eatatjacks.com
------------------------------

AnnettaColeman

Qrew Cadet

2 years ago

Yes, understand I can check or uncheck show ALL totals. My use case is the need to show totals for $ fields and not for % fields. Setting up numerous formula fields to display % complete as a text so that the % completes do not total would work but seems pretty awkward. Curious if there is a native way for the table reports to behave more intelligently. If you have 5 projects that are each 50% complete, showing the total of 250% is not useful information.

------------------------------
Annetta Coleman
------------------------------

MarkShnier__You
Qrew Legend
2 years ago
Just go to the Field Setting for the [% Complete] field and set it not to Show Totals.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------
- AnnettaColeman
  Qrew Cadet
  2 years ago
  Thanks! I knew there had to be a simpler answer.
  
  ------------------------------
  Annetta Coleman
  ------------------------------