Remaining duration/Graphical indicator

[D.]

Hi,

I seem to be doing something wrong:
I am trying to set up an alert system by graphical indicators to indicate
the number of days tasks are falling behind their scheduled completion. I
created a remaining duration colum then I created a number column where I put
the following values in the formula: IIfIIf([Remaining
Duration]=0,0,IIf([Remaining Duration]>0,1,IIf([Remaining
Duration]<5,1,IIf([Remaining Duration]>5,2,IIf([Remaining
Duration]<15,2,IIf([Remaining Duration]>15,3))))))

I also added in the graphical indicator section
equals 0 x indicator
equals 1 y indicator
equals 2 z indicator
equals 3 a indicator

For reasons that I cannot understand only t2 indicators trigger an alert:
equals 0 and
equals 1
despite the fact that the remaining duration in some instances is above 15
days ...

What am I doing wrong?

Thanks

D.

 

[Gérard Ducouret]

Hello D.
You wrote too many tests. And all the tests must be entered in an increase
order, or a decrease order.
Try the following: (translate for French to your language)
IIf([Durée restante]/[Minutes par jour]=0;0;IIf([Durée restante]/[Minutes
par jour]<5;1;IIf([Durée restante]/[Minutes par jour]<15;2;3)))

Gérard Ducouret

 

[D.]

Gerard,

Merci beaucoup de votre aide. Je me rends compte de mon erreur maintenant.
Thanks very much for your help, Gerard. I realize the mistake I made.

Have a great day!
Bonne journee.

Hello D.
You wrote too many tests. And all the tests must be entered in an increase
order, or a decrease order.
Try the following: (translate for French to your language)
IIf([Durée restante]/[Minutes par jour]=0;0;IIf([Durée restante]/[Minutes
par jour]<5;1;IIf([Durée restante]/[Minutes par jour]<15;2;3)))

Gérard Ducouret

Hi,

I seem to be doing something wrong:
I am trying to set up an alert system by graphical indicators to indicate
the number of days tasks are falling behind their scheduled completion. I
created a remaining duration colum then I created a number column where I put
the following values in the formula: IIfIIf([Remaining
Duration]=0,0,IIf([Remaining Duration]>0,1,IIf([Remaining
Duration]<5,1,IIf([Remaining Duration]>5,2,IIf([Remaining
Duration]<15,2,IIf([Remaining Duration]>15,3))))))

I also added in the graphical indicator section
equals 0 x indicator
equals 1 y indicator
equals 2 z indicator
equals 3 a indicator

For reasons that I cannot understand only t2 indicators trigger an alert:
equals 0 and
equals 1
despite the fact that the remaining duration in some instances is above 15
days ...

What am I doing wrong?

Thanks

D.

 

[D.]

Sorry to have to bother you again: I copied and pasted your formula and I
replaced the french expressions with english ones. Unfortunately, I get a
'syntax error' on the first 'colon' sign whenever I click ok...Can't figure
out what's wrong. Have you tried the formula on your own computer?

Thanks and sorry again

D.

Gerard,

Merci beaucoup de votre aide. Je me rends compte de mon erreur maintenant.
Thanks very much for your help, Gerard. I realize the mistake I made.

Have a great day!
Bonne journee.

Hello D.
You wrote too many tests. And all the tests must be entered in an increase
order, or a decrease order.
Try the following: (translate for French to your language)
IIf([Durée restante]/[Minutes par jour]=0;0;IIf([Durée restante]/[Minutes
par jour]<5;1;IIf([Durée restante]/[Minutes par jour]<15;2;3)))

Gérard Ducouret

Hi,

I seem to be doing something wrong:
I am trying to set up an alert system by graphical indicators to indicate
the number of days tasks are falling behind their scheduled completion. I
created a remaining duration colum then I created a number column where I put
the following values in the formula: IIfIIf([Remaining
Duration]=0,0,IIf([Remaining Duration]>0,1,IIf([Remaining
Duration]<5,1,IIf([Remaining Duration]>5,2,IIf([Remaining
Duration]<15,2,IIf([Remaining Duration]>15,3))))))

I also added in the graphical indicator section
equals 0 x indicator
equals 1 y indicator
equals 2 z indicator
equals 3 a indicator

For reasons that I cannot understand only t2 indicators trigger an alert:
equals 0 and
equals 1
despite the fact that the remaining duration in some instances is above 15
days ...

What am I doing wrong?

Thanks

D.

 

[Mike Glen]

I think the punctuation should be commas and not colons or semi-colons. I
haven't tried this out, but try the commas instead.

Mike Glen
Project MVP

Sorry to have to bother you again: I copied and pasted your formula
and I replaced the french expressions with english ones.
Unfortunately, I get a 'syntax error' on the first 'colon' sign
whenever I click ok...Can't figure out what's wrong. Have you tried
the formula on your own computer?

Thanks and sorry again

D.

Gerard,

Merci beaucoup de votre aide. Je me rends compte de mon erreur
maintenant. Thanks very much for your help, Gerard. I realize the
mistake I made.

Have a great day!
Bonne journee.

Hello D.
You wrote too many tests. And all the tests must be entered in an
increase order, or a decrease order.
Try the following: (translate for French to your language)
IIf([Durée restante]/[Minutes par jour]=0;0;IIf([Durée
restante]/[Minutes par jour]<5;1;IIf([Durée restante]/[Minutes par
jour]<15;2;3)))

Gérard Ducouret

"D." <[email protected]> a écrit dans le message de
Hi,

I seem to be doing something wrong:
I am trying to set up an alert system by graphical indicators to
indicate the number of days tasks are falling behind their
scheduled completion. I created a remaining duration colum then I
created a number column where I put the following values in the
formula: IIfIIf([Remaining Duration]=0,0,IIf([Remaining
Duration]>0,1,IIf([Remaining Duration]<5,1,IIf([Remaining
Duration]>5,2,IIf([Remaining Duration]<15,2,IIf([Remaining
Duration]>15,3))))))

I also added in the graphical indicator section
equals 0 x indicator
equals 1 y indicator
equals 2 z indicator
equals 3 a indicator

For reasons that I cannot understand only t2 indicators trigger an
alert: equals 0 and
equals 1
despite the fact that the remaining duration in some instances is
above 15 days ...

What am I doing wrong?

Thanks

D.

 

[Mike Glen]

You're welcome, D

Mike Glen
MS Project MVP

Rigth on the nail. I actually tried a couple of things before I came
to trying commas. Thanks Mike.

D.

I think the punctuation should be commas and not colons or
semi-colons. I haven't tried this out, but try the commas instead.

Mike Glen
Project MVP

Sorry to have to bother you again: I copied and pasted your formula
and I replaced the french expressions with english ones.
Unfortunately, I get a 'syntax error' on the first 'colon' sign
whenever I click ok...Can't figure out what's wrong. Have you tried
the formula on your own computer?

Thanks and sorry again

D.

:

Gerard,

Merci beaucoup de votre aide. Je me rends compte de mon erreur
maintenant. Thanks very much for your help, Gerard. I realize the
mistake I made.

Have a great day!
Bonne journee.



:

Hello D.
You wrote too many tests. And all the tests must be entered in an
increase order, or a decrease order.
Try the following: (translate for French to your language)
IIf([Durée restante]/[Minutes par jour]=0;0;IIf([Durée
restante]/[Minutes par jour]<5;1;IIf([Durée restante]/[Minutes
par jour]<15;2;3)))

Gérard Ducouret

"D." <[email protected]> a écrit dans le message de
Hi,

I seem to be doing something wrong:
I am trying to set up an alert system by graphical indicators to
indicate the number of days tasks are falling behind their
scheduled completion. I created a remaining duration colum then I
created a number column where I put the following values in the
formula: IIfIIf([Remaining Duration]=0,0,IIf([Remaining
Duration]>0,1,IIf([Remaining Duration]<5,1,IIf([Remaining
Duration]>5,2,IIf([Remaining Duration]<15,2,IIf([Remaining
Duration]>15,3))))))

I also added in the graphical indicator section
equals 0 x indicator
equals 1 y indicator
equals 2 z indicator
equals 3 a indicator

For reasons that I cannot understand only t2 indicators trigger
an alert: equals 0 and
equals 1
despite the fact that the remaining duration in some instances is
above 15 days ...

What am I doing wrong?

Thanks

D.