• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 475
  • Last Modified:

Empty Cell in Cross Tab to populate with "N/A"

: Hi,

I'm trying to figure out an issue with a Cross-Tab I have created in Crystal 2008.  The rows I am using are from a field called asset type.  The Columns are from a field called Test.description.  Each asset type field  has a number of test (test descriptions).  The Summarized field is called result text.  

However, because the asset types don't all have the same number of tests, there are a lot of blank cells.  Is there a way I can default these to say "N/A" so the user knows there is nothing to expect in that cell as opposed to think the tech just didn't enter the (result text field) test?

Hope this makes sense.

Thanks in advance!
  • 2
2 Solutions
As I stated in your other question I can't find anyway to get a "VALUE" for the empty cells to test.

Here is an idea that might work

jjg1576Author Commented:
Thanks again- I was trying to upload a different report, but I think this will work.
jjg1576Author Commented:
Solution worked- formula populates cell with N/A
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now