Expand my Community achievements bar.

Reporting Help

Avatar

Level 7
Hi All, I am currently trying to use a calculated view to get the difference between a parent task planned completion date and a child task planned completion date. The text I have in text mode so far is: linkedname=direct namekey=plannedCompletionDate textmode=true valueexpression=DATEDIFF({parent:plannedCompletionDate},{plannedCompletionDate}) valueformat=HTML I have used pretty much exactly the same text in another report on a different set of fields and it has worked so not sure what I am doing wrong here or if this is just not possible. If anyone has managed to report on this before or has any advice on why it isn't working I would be grateful. Thank you, Vicky. Vicky Fitzgerald
1 Reply

Avatar

Level 4
Try valueexpression=DATEDIFF({parent}.{plannedCompletionDate},{plannedCompletionDate}) -- Melinda Layten, Senior Consultant Work Management Improvement CapabilitySource Phone: (484) 505-6855 site: www.capabilitysource.com email: melinda.layten@capabilitysource.com - we simplify your work so you can run your business -