Help with a formula

[hanni]

Hi all,

I would like to see all dalays on the tasks
I put the formula: IIf([Actual Finish]>[Deadline],1,0) on "number1"
culmn
but, it gives me "0" even on tasks that are delayed (i.e. actual
finish: September 18 and deadline is September 9)

Thanks

 

[JulieS]

Hello Hanni,

I just quickly tested your formula and it seems to work just fine. A
quick comment however, it will only show "1" if you have marked the task
complete (using Actual Finish). I would want to know if the task was
later than the deadline *before* I reached the actual finish, so I would
most likely use a formula:

IIf([Finish]>[Deadline],1,0)

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[hanni]

The purpose of this is to show how many late arrivles we had in
retrospect.
I have actual days for these tasks and still receive "0" in the
formula culmn... :-(
any other suggestions I dont think about?

Thanks,
Hanni

 

[Mike Glen]

Hi Hanni,

Just a thought. When you state Deadline, do you mean the Finish Date, or
have you actually set a Deadline Date (via the Task Information dialog in
the Advanced tab)? The field Deadline picks up the Deadline Date you have
entered.

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[JulieS]

Good pickup Mike -- Julie

Hi Hanni,

Just a thought. When you state Deadline, do you mean the Finish Date,
or have you actually set a Deadline Date (via the Task Information
dialog in the Advanced tab)? The field Deadline picks up the Deadline
Date you have entered.

Hope this helps - please let us know how you get on

Mike Glen
MS Project MVP
See http://tinyurl.com/2xbhc for Project Tutorials

 

[hanni]

Hi,

I use the deadline field on the advance.
I even added the dealine and the actual finish culmns next to the
formula and I see tasks that defenatly sohuld give me "1" (marks a
delay) and I see there "0" (=no delay)

Hanni

 

[JulieS]

Hello Hanni,

Is "1" showing on any tasks? If you are seeing "0" where you should be
seeing a "1" is it a summary task? When you customized the Number1
field with the formula, in order to calculate at the summary row, you
need to specifically set the calculation for group or summary row to use
the formula.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

 

[Ginger]

Hi Julie --

I'm trying to learn more about fomulas, so I added a Text1 column and the
copied this formula in at Task 1. It just shows the formula instead of the
result.

What am I doing wrong?

-tks-

-- Ginger

Hello Hanni,

I just quickly tested your formula and it seems to work just fine. A
quick comment however, it will only show "1" if you have marked the task
complete (using Actual Finish). I would want to know if the task was
later than the deadline *before* I reached the actual finish, so I would
most likely use a formula:

IIf([Finish]>[Deadline],1,0)

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Hi all,

I would like to see all dalays on the tasks
I put the formula: IIf([Actual Finish]>[Deadline],1,0) on "number1"
culmn
but, it gives me "0" even on tasks that are delayed (i.e. actual
finish: September 18 and deadline is September 9)

Thanks

 

[JulieS]

Hello Ginger,

You need to make sure you enter the formula in the correct area.
Choose Tools > Customize > Fields in the menu to show the Customize
Fields dialog box. Click the formula button to open the "Formula for
Text1" dialog box and either enter or copy/paste the formula. Click
the OK button to close the "Formula for Text1" dialog box and return
to the Customize Fields dialog box. If you want to use the formula on
summary task lines, click the "Use formula" choice under the
"Calculation for group or summary rows area". Click OK to close the
Customize fields dialog box. Your Text1 field should now show the
result of the calculation.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Hi Julie --

I'm trying to learn more about fomulas, so I added a Text1 column
and the
copied this formula in at Task 1. It just shows the formula instead
of the
result.

What am I doing wrong?

-tks-

-- Ginger

Hello Hanni,

I just quickly tested your formula and it seems to work just fine.
A
quick comment however, it will only show "1" if you have marked the
task
complete (using Actual Finish). I would want to know if the task
was
later than the deadline *before* I reached the actual finish, so I
would
most likely use a formula:

IIf([Finish]>[Deadline],1,0)

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Hi all,

I would like to see all dalays on the tasks
I put the formula: IIf([Actual Finish]>[Deadline],1,0) on
"number1"
culmn
but, it gives me "0" even on tasks that are delayed (i.e. actual
finish: September 18 and deadline is September 9)

Thanks

 

[Ginger]

Thank you so much! This is working now.

-- Ginger

Hello Ginger,

You need to make sure you enter the formula in the correct area.
Choose Tools > Customize > Fields in the menu to show the Customize
Fields dialog box. Click the formula button to open the "Formula for
Text1" dialog box and either enter or copy/paste the formula. Click
the OK button to close the "Formula for Text1" dialog box and return
to the Customize Fields dialog box. If you want to use the formula on
summary task lines, click the "Use formula" choice under the
"Calculation for group or summary rows area". Click OK to close the
Customize fields dialog box. Your Text1 field should now show the
result of the calculation.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional information
about Microsoft Project

Hi Julie --

I'm trying to learn more about fomulas, so I added a Text1 column
and the
copied this formula in at Task 1. It just shows the formula instead
of the
result.

What am I doing wrong?

-tks-

-- Ginger

Hello Hanni,

I just quickly tested your formula and it seems to work just fine.
A
quick comment however, it will only show "1" if you have marked the
task
complete (using Actual Finish). I would want to know if the task
was
later than the deadline *before* I reached the actual finish, so I
would
most likely use a formula:

IIf([Finish]>[Deadline],1,0)

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project


Hi all,

I would like to see all dalays on the tasks
I put the formula: IIf([Actual Finish]>[Deadline],1,0) on
"number1"
culmn
but, it gives me "0" even on tasks that are delayed (i.e. actual
finish: September 18 and deadline is September 9)

Thanks

 

[JulieS]

You're most welcome Ginger and thanks for the feedback.

Julie
Project MVP

Thank you so much! This is working now.

-- Ginger

Hello Ginger,

You need to make sure you enter the formula in the correct area.
Choose Tools > Customize > Fields in the menu to show the Customize
Fields dialog box. Click the formula button to open the "Formula
for
Text1" dialog box and either enter or copy/paste the formula.
Click
the OK button to close the "Formula for Text1" dialog box and
return
to the Customize Fields dialog box. If you want to use the formula
on
summary task lines, click the "Use formula" choice under the
"Calculation for group or summary rows area". Click OK to close
the
Customize fields dialog box. Your Text1 field should now show the
result of the calculation.

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project

Hi Julie --

I'm trying to learn more about fomulas, so I added a Text1 column
and the
copied this formula in at Task 1. It just shows the formula
instead
of the
result.

What am I doing wrong?

-tks-

-- Ginger

:

Hello Hanni,

I just quickly tested your formula and it seems to work just
fine.
A
quick comment however, it will only show "1" if you have marked
the
task
complete (using Actual Finish). I would want to know if the
task
was
later than the deadline *before* I reached the actual finish, so
I
would
most likely use a formula:

IIf([Finish]>[Deadline],1,0)

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information
about Microsoft Project


Hi all,

I would like to see all dalays on the tasks
I put the formula: IIf([Actual Finish]>[Deadline],1,0) on
"number1"
culmn
but, it gives me "0" even on tasks that are delayed (i.e.
actual
finish: September 18 and deadline is September 9)

Thanks