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
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.
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?
Gianluca Coppola – Thank you. Have you selected “Use formula” for “Calculation for task and summary rows” — see the picture in my previous reply?
I feel really stupid!!!:-)
thank you so much, ciao
You are welcome
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.