Formulas for Enterprise Custom Fields

A

Angela

Anybody know of a good site to help with formulas for Enterprise Custom
Fields? Trying to make a field with indicators to compare work with baseline
work:

Work Variance Indicator

Green Indicator - less than 5% over baseline work
Yellow Indicator - 5-15% over baseline work
Red Indicator - 15%+ over baseline work
 
D

Dale Howard [MVP]

Angela --

There's no Web site or book that deals specifically with formulas in
enterprise custom fields. However, to answer your question, here's what I
would do:

1. Create a new enterprise custom task Number field
2. Enter the following formula for the field:

[Work Variance]/[Baseline Work]

3. Select the "Use formula" option for task and group summary rows.
4. Create Graphical Indicator criteria as follows:

Is greater than or equal to .15 Red indicator
Is greater than or equal to .05 Yellow indicator
Is less than .05 Green
indicator

Hope this help.s
 
S

Stephen Sanderlin

You could also use this formula:

IIf([Baseline Finish]=ProjDateValue("NA"),"Not Baselined",IIf([Work
Variance]/[Baseline Work]<0.05,"Less than 5% over Baseline
Work",IIf([Work Variance]/[Baseline Work]<0.15,"5 - 15% over Baseline
Work",IIf([Work Variance]/[Baseline Work]>0.15,"15%+ over Baseline
Work","Error"))))

and slightly modify Dale's instructions for configuring the indicator.

--
Stephen Sanderlin
Owner/Founder - EPMFAQ
http://www.epmfaq.com/
http://forums.epmfaq.com/

EPM Solutions Architect / Principal Consultant - BT Professional
Services
http://bt.ins.com/

This electronic message, along with any information, advice, and
opinions it contains, are mine alone and are not representative of my
employer. All information is provided in "GOOD FAITH" and on an "AS IS"
basis only. I provide no presentations or warranties, express or
implied, including implied warranties of fitness for a particular
purpose, merchantability, title, and noninfringement. I strongly advise
you to extensively test any changes, workarounds, or techniques
described herein on a development system prior to implementation in a
production environment, and you are hereby notified that I bear no
responsibility whatsoever for any loss, harm, or otherwise negative
outcomes resulting from your actions, whether or not said actions were
a result of this electronic message, directly or indirectly.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top