CODEWITHSUNDEEP
ms-project
eusataf
eusataf

Reputation: 897

How to calculate cumulative costs using formulas?

Used by:
  - MS Project 2016 Pro. Desktop

I am in the Gantt Chart view.

How to calculate cumulative costs using formulas? enter image description here

Upvotes: 1

Views: 1548

Answers (1)

Rachel Hettinger
Rachel Hettinger

Reputation: 8442

Formulas are task-level calculations and cannot get/use information from other tasks.

You could do this with VBA, however since the order of tasks is mutable (e.g. tasks can be moved, deleted, inserted, etc) it doesn't make much sense to have a field showing cumulative values. You would need to recalculate the field frequently to ensure it is correct.

Upvotes: 2

Related Questions