Hide Null Values? | Community
Skip to main content
J
JasonLe2
Level 2
October 4, 2019
Question

Hide Null Values?

  • October 4, 2019
  • 3 replies
  • 754 views
So I'm making a project report showing actual hours worked, grouped by a calc field for a multi-select checkbox, in a chart. I'd like to be able to hide checkbox values with no hours worked. Is this possible? Jason Lego Stanley Black & Decker, Inc.
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

S
SkyeHa
Level 10
October 4, 2019
can you do that before you even get the report? So in other words, filter out Project > Actual Hours > null? If they don't show up on the report you don't have to group by them, right? -skye
J
JasonLe2Author
Level 2
October 4, 2019
Hi Skye! Not quite. The custom form on the projects has two multi-select fields indicating two different menus of services available. Some services have not yet been selected, so no hours are attributable to those selections. In the resulting report, the bar graph shows zero hours for that selection. I'd like to hide those selections with no hours attributed to them. Does that make sense? Jason Lego Stanley Black & Decker, Inc.
S
SkyeHa
Level 10
October 5, 2019
Honestly, I have a hard time picturing something that isn't in front of my face :) so I'm of limited help. Is it possible that what you are describing is some sort of a complicated calc statement? Like are you saying "if !isblank hours, show this"? -skye
Terms & ConditionsAccessibility statement

Loading footer...