January 24, 2023
I have the following formulas that work well but it would be beneficial if they did NOT return the zero (0) results.
this ones an array
Just trying to make things look a bit smarter when I graph all the data
October 17, 2018
The result will have to show something, a blank or a 0but if you perform calculations on these columns a blank cell might cause issues.
What you can do is add a Conditional format to the column or columns that if the value is 0 to make the font color white, that way it is there but you won't see it.
Another way is the Custom Number format, you format it only por ppositive and negative numbers and nothing for zero's
;;; will show an empty cell
Hope my explanation makes sense
November 1, 2018
January 24, 2023
NO NEED TO ADVISE - LEFT HERE AS A MATTER OF INTEREST - ISSUE RESOLVED (Just made the default in their SharePoint List default as 0 for the relevant columns)
The when I graph is probably a red herring; what I'm really looking at is getting a return of nothing if there is no number.
There are two formulas at play here
The first looks at a specific row on an owssvr; this looks at a specific week and extracts two pieces of data (these being)
1. A Unit, and
2 the number of people in that unit (TTS 5, CRTS 103 etc.)
The fomula above then looks for the unit (A6) in the column (C9: C250) if it finds it, then it retrns the number of pers in that unit for that week VALUE(RIGHT(C$9:C$250,FIND($A6,C$9:C$250)+1)),0))}
The issue is if; the wek period has not yet arrived, or if someone hasn't completed the data for the owssvr thenn there is no number to return so I get a #Value error.
I can live with it; but was just wondering if there was a way to get it to return blank if no number exists
Cheers and as always