Skip to main content
Question

How to mask % totals on summary line of report

  • August 30, 2023
  • 0 replies
  • 77 views

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 not all numeric fields?



------------------------------
Annetta Coleman
------------------------------
      This topic has been closed for replies.

      MarkShnierYou
      Forum|alt.badge.img+22
      • MarkShnierYou
      • Quickbase Alumni
      • August 30, 2023

      Do you mean table reports?  if so, its a field property to set if you want Totals or Averages to show.  All numeric fields including percent fields default to showing totals and not averages.



      ------------------------------
      Mark Shnier (Your Quickbase Coach)
      mark.shnier@gmail.com
      ------------------------------
      Mark Shnier. Your Quickbase Coach
      Forum|alt.badge.img+9
      • katlyncowley
      • Quickbase Alumni
      • August 31, 2023
      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
      ------------------------------

        Terms & ConditionsAccessibility statement