Schedule Variation

[Thew21]

Im trying to create a formula to work out the variation in baseline start and
actual start, i used the formula ([Baselined Start]-[Actual Start]) and this
works fine however it calculates it for all the tasks not just ones that have
begun so i end up with some very strange number sequences from ones that have
no actual start date.

So I tried using Iif([Baseline Start]<-now(),"([Baselined Start]-[Actual
Start])"," ")

However this seems totally wrong as all my columns now show ([Baselined
Start]-[Actual Start]).

If anyone could help that would be great. If not I can just filter the date.

Thanks Richard

 

[Jan De Messemaeker]

Hi,
How about
Iif([Percent Complete>0,[Baselined Start]-[Actual Start]," ")
HTH

 

[Jan De Messemaeker]

Hi,

This is better (in a number field)
IIf([% Complete]>0;[Baseline Start]-[Actual Start];0)

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I get a syntax error when I tried that formula

Hi,
How about
Iif([Percent Complete>0,[Baselined Start]-[Actual Start]," ")
HTH
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Im trying to create a formula to work out the variation in baseline
start
and
actual start, i used the formula ([Baselined Start]-[Actual Start]) and
this
works fine however it calculates it for all the tasks not just ones
that
have
begun so i end up with some very strange number sequences from ones
that
have
no actual start date.

So I tried using Iif([Baseline Start]<-now(),"([Baselined
Start]-[Actual
Start])"," ")

However this seems totally wrong as all my columns now show ([Baselined
Start]-[Actual Start]).

If anyone could help that would be great. If not I can just filter the
date.

Thanks Richard

 

[Gérard Ducouret]

Hi Richard,

You have a strange minus sign before Now(), and some quotes on both sides of
your substraction.
Try the following :
IIf([Baseline Start]<Now(),([Baselined Start]-[Actual Start]),0)
Hope this helps,

Gérard Ducouret

 

[Thew21]

Hi thats great, however I found it didnt work with ';' though replaced them
with ',' and it work perfectly

Hi,

This is better (in a number field)
IIf([% Complete]>0;[Baseline Start]-[Actual Start];0)

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I get a syntax error when I tried that formula

Hi,
How about
Iif([Percent Complete>0,[Baselined Start]-[Actual Start]," ")
HTH
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Im trying to create a formula to work out the variation in baseline
start
and
actual start, i used the formula ([Baselined Start]-[Actual Start]) and
this
works fine however it calculates it for all the tasks not just ones
that
have
begun so i end up with some very strange number sequences from ones
that
have
no actual start date.

So I tried using Iif([Baseline Start]<-now(),"([Baselined
Start]-[Actual
Start])"," ")

However this seems totally wrong as all my columns now show ([Baselined
Start]-[Actual Start]).

If anyone could help that would be great. If not I can just filter the
date.

Thanks Richard

 

[Jan De Messemaeker]

Hi,

That is the American List separator, I had the European one.
Greetings,

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

Hi thats great, however I found it didnt work with ';' though replaced
them
with ',' and it work perfectly

Hi,

This is better (in a number field)
IIf([% Complete]>0;[Baseline Start]-[Actual Start];0)

--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade

I get a syntax error when I tried that formula

:

Hi,
How about
Iif([Percent Complete>0,[Baselined Start]-[Actual Start]," ")
HTH
--
Jan De Messemaeker
Microsoft Project MVP
http://users.online.be/prom-ade
Im trying to create a formula to work out the variation in baseline
start
and
actual start, i used the formula ([Baselined Start]-[Actual Start])
and
this
works fine however it calculates it for all the tasks not just ones
that
have
begun so i end up with some very strange number sequences from ones
that
have
no actual start date.

So I tried using Iif([Baseline Start]<-now(),"([Baselined
Start]-[Actual
Start])"," ")

However this seems totally wrong as all my columns now show
([Baselined
Start]-[Actual Start]).

If anyone could help that would be great. If not I can just filter
the
date.

Thanks Richard