Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

How to make an alias for zero on a report only

I have a report that displays zero if the value is zero.  OK, but now I need to display the zero as N/A instead of zero.  How do I do this?  One text box I have has this code as the control source.

=IIf([AskPrice]>0,[AskPrice],"")

Thanks

0
napsternova
Asked:
napsternova
  • 2
  • 2
1 Solution
 
omgangCommented:
=IIf([MyField]=0,"N/A",[MyField])
OM Gang
0
 
napsternovaAuthor Commented:
Where would this go exactly?  Is it added to the control source?
0
 
omgangCommented:
You can add a new, unbound, Textbox control to your report and enter the expression as the ControlSource.
OM Gang
0
 
napsternovaAuthor Commented:
I think I actually just need to replace the control source that was there.  Thanks
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

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