Re: Formula - Project SV?

Sorry,
Was typing without thinking. It should be:
ActiveProject.ProjectSummaryTask.SV

-Jack

"G Lykos" <GLykos@xxxxxxxxxxxxxx> wrote in message
news:eVCLU9iTHHA.4744@xxxxxxxxxxxxxxxxxxxxxxx
Thanks, Jack. Yes, a custom-field formula was the idea, for simplicity
and
automation. I had the feeling from having read your posts on this subject
that a project-level SV is not available to a formula but thought I would
ask. A VBA solution is a fall-back alternative.

What specifically is ActiveProject.Tasks(1) in relation to the entire
project - (Project Summary) Task ID 0?

George


"Jack Dahlgren" <jack@xxxxxxxx> wrote in message
news:O2cu4IhTHHA.3440@xxxxxxxxxxxxxxxxxxxxxxx
I don't think that will give you very meaningful results...
It is not possible in a custom field formula either as Project SV is not
available to that formula.
You could use a visual basic macro like this to write the value into the
text1 field though:

Sub svthing()
For Each Task In ActiveProject.Tasks
If Not Task Is Nothing Then
Task.Text1 = (Task.SV / ActiveProject.Tasks(1).SV) * 100 & "%"
End If
Next Task
End Sub



-Jack Dahlgren
More about programming MS Project at http://zo-d.com/blog



"G Lykos" <GLykos@xxxxxxxxxxxxxx> wrote in message
news:%23sG%23EogTHHA.4744@xxxxxxxxxxxxxxxxxxxxxxx
Greetings! Am interested in calculating the SV contribution of each
task
expressed as a percentage. Formula would look something like {Task SV}
/
{Project SV} * 100.

Task SV is captured as [SV]. How about Project SV?

Thanks,
George








.

Relevant Pages

  • Re: Formula - Project SV?
    ... Yes, a custom-field formula was the idea, for simplicity and ... I had the feeling from having read your posts on this subject ... It is not possible in a custom field formula either as Project SV is not ... Sub svthing() ...
    (microsoft.public.project)
  • Re: VB or C# for SQL Server
    ... Bob, ... I was just reading through the posts, and got to the part where you ... I was actually doing something similiar, where I needed to control the ... Public Sub Button_Click ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Copy range if column N is empty
    ... also learning a lot from all the posts here. ... Dim sh1 As Worksheet, sh2 As Worksheet ... Sub terranean() ...
    (microsoft.public.excel.programming)
  • Re: Multiple List Views ?
    ... Sorry about the quick posts just figured out the problem, ... > A circular control reference has been made. ... > Public Sub Sublstview_ItemActivate(ByVal sender As Object, ... >> AddHandler SubLstView.ItemActivate, AddressOf ...
    (microsoft.public.dotnet.languages.vb)
  • notinlist event gives error
    ... I have read the posts and visited the vb links related to this action, ... inserting the new item into the underlying table, the request to requery the ... Private Sub Combo0_NotInList(NewData As String, ...
    (microsoft.public.access.formscoding)