|
How about (((A1:7D/B1:5D)'=0.00)-1)*100 - Note: with an
apostrophy before the = as in... ONLY IF, A1/B1 does NOT = 0.00,
then subtract 1, then multiply by 100. Though, I'm taking a guess here as
I'm not able to test it out. The question is... what will be returned if
A1/B1 DOES = 0.00???
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Rhodes-Bridges,Barbara Sent: Monday, October 30, 2006 10:10 AM To: [email protected] Subject: [MEDITECH-L] BF View Question 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
