how can I calculate duration of a summary task?

Home Forums Discussion Forum how can I calculate duration of a summary task?

Viewing 6 reply threads
  • Author
    Posts
    • #300831
      Gianluca Coppola
      Guest

      goodmorning everybody,

      I’ve this problem:
      I’d like to add a column in which I want to show the duration of tasks and summary tasks in calendar (solar) days. I’ve added a column, formatted as number, in which I’ve put this formula: “DateValue([Fine])-DateValue([Inizio])” (“fine” stands for end, “inizio” for start), but I get numbers with two decimal (17.38 days…?) for tasks, and I get 0 for summary tasks.
      could anyone help me?

      thanks in advance

    • #300854
      Sai Prasad
      Participant

      Gianluca Coppola – By solar days, I suppose you meant calendar days between start and finish. Insert a Number1 column and you can use DateDiff(). DateDiff(“d”,[Start],[Finish]) returns the number of calendar days between Start and Finish but this function will return a value one less that what is expected. For example, for Start = 1 Jan, Finish = 1 Jan, this function will return 0 but we expect 1. So, in the formula add 1 to the returned value. Let me know if this helps.

    • #300878
      Gianluca Coppola
      Guest

      Hi, thank you very much for your help. the formula work properly with tasks, but I still get a “0” for the summary tasks. What’s wrong?
      thanks again

    • #300879
      Sai Prasad
      Participant

      Gianluca Coppola – Thank you. Have you selected “Use formula” for “Calculation for task and summary rows” — see the picture in my previous reply?

    • #300880
      Gianluca Coppola
      Guest

      I feel really stupid!!!:-)

      thank you so much, ciao

    • #300882
      Sai Prasad
      Participant

      You are welcome

    • #308144
      Malathi
      Guest

      Hi Sai,

      I am also facing this same problem.. Can you please elaborate in detail about the above mentioned solution.. It will be very helpful for me . Thanks in advance.

      Regards,
      Malathi R
      CBAP training

Viewing 6 reply threads
  • You must be logged in to reply to this topic.