Re: Formula for stoplight

Tech-Archive recommends: Fix windows errors by optimizing your registry

Looks like you are missing some closing parenthesis at the end of your
formula which explains why the cursor moves to the end of your formula after
throwing the error.

Actuall, all of your IIf statements execpt the first one need to have a
start open paranthesis. The syntax is IIF(conditional statement,true,false)

Jonathan

"Hawk" <Hawk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5A5857CF-139F-4935-8E89-AAA5DF1036EF@xxxxxxxxxxxxxxxx
Hello... I need some help with a formula in project. I found a stoplight
formula and it works fine, but I need to tweak it a little bit to match my
boss's needs. Problem is, when i try to understand the logic/syntax and
adjust it, i get a user error. i must be missing a character or something
because it just won't work, and after i get the error, it places the
cursor
at the end of the formula instead of highlighting the problem. Here's
what
i want it to show me: ---if tasks or milestones are (baselined to start)
in
the future, show 1. if tasks or milestones are 100%, show 2. if tasks are
on
track to finish according to the baselined dates, show 2. if tasks are
baselined to finish three days from now and the % complete is more than
60%,
show 2. if tasks are baselined to finish three days from now and the %
complete is more than 50 but less than 59%, show 3. if tasks are
baselined
to finish one day from now and the % complete is more 40 but less than
49%,
show 4. if tasks are 5 days late (using baselined finish date) and the %
complete is less than 60%, show 5. if tasks are 10 days late (using
baselined finish date) and the % complete is less than 60%, show 6.

this is what i came up with, but like i said, there's an error somewhere
(or
lots of somewheres...!)

If the task is 100% or the ratio of how much should be done is on time,
GREEN
IIf(([% Complete]=100 Or [% Complete]>100*(Abs((Now()-[Actual
Start])/([Baseline Finish]-[Baseline Start])))),2,IIf[Baseline
Finish]>Now()-3 And [% Complete]<80,3,IIf[Baseline Finish]>Now()-4 And [%
Complete]<70,4,IIf[Baseline Finish]>Now()-5 And [%
Complete]<60,5,IIf[Baseline Finish]>Now()-10 And [%
Complete]<60,6,IIf[Baseline Start] Or [Start]>Now(),1

Any help would be very much appreciated since the help on project's
formulas
didn't assist me much....


.

Relevant Pages

  • Re: Missing mouse pointer schemes
    ... installed those files to the Cursors folder. ... Properties they were all there and all the previous missing ones work fine ... files- the same cursor files as before. ... It seems like I've lost half of the long list of schemes available in mouse ...
    (microsoft.public.windowsxp.general)
  • Re: update problem
    ... >> looks like you are missing the text-delimiters. ... >so i am missing something with the nature of the cursor in VFP... ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Missing mouse pointer schemes
    ... of the cursor files weren't installed or corrupted. ... C:\Windows\Cursors that I'm missing the cursor files that should be in there. ... Mouse properties and the missing pointers were added- BUT, ... It seems like I've lost half of the long list of schemes available in mouse ...
    (microsoft.public.windowsxp.general)
  • Re: update problem
    ... > looks like you are missing the text-delimiters. ... so i am missing something with the nature of the cursor in VFP... ... record of the cursor - and the update command ONLY updates that record. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Expression error
    ... Now I'm getting an error that says it's missing a closing parenthesis, ... so I added a third closing parenthesis after the ... Double check to make sure the time fields really are ...
    (microsoft.public.access.reports)