1

Replace Zero with blank or "-"

Is there a way to suppress showing zeros?  My users would rather see and empty cell or a dash instead of a zero. Here is an example:

5replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Use a conditional format with the background and text ( or number ) both white.

    Like 2
      • Szara Loring
      • eCapital Advisors
      • Szara_Loring
      • 1 mth ago
      • Reported - view

      R. A. Dawson Sr Thanks, I tried that, but then the white shows up on the rows that are shaded gray. :)

      Like
  • I'll submit another option on top of  I used on a listing table - creating a conditional formula:
     

    if({Completed Qty} = 0, null(),{Completed Qty} )
    Like 2
      • Szara Loring
      • eCapital Advisors
      • Szara_Loring
      • 1 mth ago
      • 1
      • Reported - view

      Joe Miller Awesome!  I think that will do the trick.

      Like 1
      • Szara Loring
      • eCapital Advisors
      • Szara_Loring
      • 1 mth ago
      • 1
      • Reported - view

      Joe Miller null() worked perfectly.

      Like 1
Like1 Follow
  • Status Answered
  • 1 Likes
  • 1 mth agoLast active
  • 5Replies
  • 18Views
  • 3 Following

Product Announcement

A new community experience is coming! If you would like to have beta access to provide feedback, please contact us at community@incorta.com.