Formula help needed, please, on % Complete and Text1 with a %

[Ginger]

I have the following formula in Text1 - which seems to be working fine. It
shows me what percentage of work should be complete at the current date...
presuming an even work effort over the duration.

Left(str(IIf([Current Date]<[Start],"0",IIf([Current
Date]>[Finish],"1",ProjDateDiff([Start],[Current
Date])/[Duration]))*100),4)+"%"

I am now trying to get a column to display which lines are falling behind
with this formula:

IIf([% Complete]>[Text1],"OK","RED")

Unfortunately, this always displays OK, even if the percent complete is
behind with a current percentage less than the percent in Text1.

Any help would be appreciated.

If anyone has any good books to recommend for studying formulas further, I'd
appreciate knowing that too. Tks.

 

[John]

I have the following formula in Text1 - which seems to be working fine. It
shows me what percentage of work should be complete at the current date...
presuming an even work effort over the duration.

Left(str(IIf([Current Date]<[Start],"0",IIf([Current
Date]>[Finish],"1",ProjDateDiff([Start],[Current
Date])/[Duration]))*100),4)+"%"

I am now trying to get a column to display which lines are falling behind
with this formula:

IIf([% Complete]>[Text1],"OK","RED")

Unfortunately, this always displays OK, even if the percent complete is
behind with a current percentage less than the percent in Text1.

Any help would be appreciated.

If anyone has any good books to recommend for studying formulas further, I'd
appreciate knowing that too. Tks.

Ginger,
A similar question was asked last week in this newsgroup. Search for a
posting by Rich Kooyer on Jan 22, 2008. Unfortunately I don't have the
subject of his post, but he was having trouble with a formula using the
% Complete field.

Hope this helps.
John
Project MVP

 

[Ginger]

Thank you, John.

-- G

I have the following formula in Text1 - which seems to be working fine. It
shows me what percentage of work should be complete at the current date...
presuming an even work effort over the duration.

Left(str(IIf([Current Date]<[Start],"0",IIf([Current
Date]>[Finish],"1",ProjDateDiff([Start],[Current
Date])/[Duration]))*100),4)+"%"

I am now trying to get a column to display which lines are falling behind
with this formula:

IIf([% Complete]>[Text1],"OK","RED")

Unfortunately, this always displays OK, even if the percent complete is
behind with a current percentage less than the percent in Text1.

Any help would be appreciated.

If anyone has any good books to recommend for studying formulas further, I'd
appreciate knowing that too. Tks.

Ginger,
A similar question was asked last week in this newsgroup. Search for a
posting by Rich Kooyer on Jan 22, 2008. Unfortunately I don't have the
subject of his post, but he was having trouble with a formula using the
% Complete field.

Hope this helps.
John
Project MVP

 

[John]

Thank you, John.

-- G

Ginger,
You're welcome.
John

I have the following formula in Text1 - which seems to be working fine.
It
shows me what percentage of work should be complete at the current
date...
presuming an even work effort over the duration.

Left(str(IIf([Current Date]<[Start],"0",IIf([Current
Date]>[Finish],"1",ProjDateDiff([Start],[Current
Date])/[Duration]))*100),4)+"%"

I am now trying to get a column to display which lines are falling behind
with this formula:

IIf([% Complete]>[Text1],"OK","RED")

Unfortunately, this always displays OK, even if the percent complete is
behind with a current percentage less than the percent in Text1.

Any help would be appreciated.

If anyone has any good books to recommend for studying formulas further,
I'd
appreciate knowing that too. Tks.

Ginger,
A similar question was asked last week in this newsgroup. Search for a
posting by Rich Kooyer on Jan 22, 2008. Unfortunately I don't have the
subject of his post, but he was having trouble with a formula using the
% Complete field.

Hope this helps.
John
Project MVP