|
Thanks, Jeff, Gary and Brian for your input. I finally got it resolved by doing the following:
Step 1: _expression_: (((A1-B1):7D/B1:5D)*100)^X,IF{X=(0-100.00) 0;X} Where _expression_ name is exp1, A1 represents 2006 YTD Actual Expenses, B1 represents 2005 YTD Actual Expenses.
Step 2: _expression_: IF{A1=(0-100.00) 0.00;A1} Where A1 represents the value resulting from step 1.
If you put the statements together, it’s logical and should be doable in one step but for some reason it didn’t like me trying to evaluate the output of my calculation and then determine the result for the field based on that output. Go figure.
FYI: BF = Budgeting and Forecasting (part of ESS-Executive Support System).
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]
-----Original
Message-----
I would try ((A1:7D/B1:5D)+(0-1))*100 .
Jeff Thompson, R.Ph. Pharmacy Informatics Newman Regional Health
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Rhodes-Bridges,Barbara 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
