|
I have created a B/F view on which there is a computed
view field. When this field encounters zeros for all values, the result
is a negative 100.00. How can I change my formula to reflect zero or
blank when this occurs?
Meditech gave the following remedy: this could
be done by changing the formula to be: (((A1:7D/B1:5D)-1)!0)*100.
However, this remedy will not work because sometimes negative values are appropriate.
Does anyone have any other ideas?
Barbara Rhodes-Bridges Applications Programmer Analyst Palos Community Hospital 12251 S. 80th Avenue Palos Heights, IL 60463 Phone: 708-923-4953 Fax: 708-923-4512 E-Mail: [EMAIL PROTECTED]
This message and accompanying documents are covered by the Electronic Communications Privacy Act and the Health Insurance Portability and Accountability Act. This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is confidential and/or privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender immediately by e-mail, and delete the original message. Thank you. |
====================================== All messages should be posted in plain text. HTML will be converted to attachments.
The meditech-l web site is MTUsers.com ______________________________________ meditech-l mailing list [email protected] http://mtusers.com/mailman/listinfo/meditech-l
