Task duration in a formula

  • 1
  • Question
  • Updated 1 year ago
Hi, I am creating a number of formulas in order to work out the expected budget for a proposal. I am building this up using a combination of task information I.E. Duration and resources and formula I.E. expense costs per day, resource unit costs etc.

Question, is it possible to include task information into a formula so I can update for example the task duration and have my formula recalculate

Something like [Resource Cost]=SUM(Self[Unit Cost]*[TASK DURATION VALUE])

Thanks you in advance

Steph
Photo of Stéphane PENOT

Stéphane PENOT

  • 2 Posts
  • 0 Reply Likes

Posted 1 year ago

  • 1
Photo of Nigel Goult (Olympic & MIVAP)

Nigel Goult (Olympic & MIVAP)

  • 344 Posts
  • 133 Reply Likes
You cannot achieve this in MindManager 2017 as is but it is possible through the Extended Properties functionality provided by the MAP for MindManager add-in.
This will enable you to read Task values into a Custom Property which can then be referenced within Formulas. They are converted to minutes but you could easily account for this in the Formula.



You can read more about it in the Interactive MAP User Guidance Map, produced with the new MindManager Export to HTML5 available here: Interactive MAP User Guide.
When you open the Map go to: Guide to MAP Functions->Topic Properties->Extended Properties and open the Notes.
I developed MAP and if you have any questions then please feel free to contact me using the contact page on our website which is linked below.
Regards
Nigel

Contact Olympic
More on MAP for MindManager
Photo of Stéphane PENOT

Stéphane PENOT

  • 2 Posts
  • 0 Reply Likes
Thank you for this add. I go to try this add'in