MindManager Cost facility - no way to use in formulas or relate to topic properties?

  • 1
  • Question
  • Updated 6 months ago
The ability to add a cost quickly and easily to a topic and then roll it up is great, but as far as I can tell there is no way to link the cost to topic properties, nor does there seem to be a way to manipulate topic costs with formulas. This seems to be a major oversight, for example, if you wanted to use formulas to sum up different topic properties to generate cost totals at the topic level, or to integrate them with other variables at the main topic or central topic levels.
Photo of Alex Gooding

Alex Gooding, Champion

  • 1209 Posts
  • 311 Reply Likes

Posted 8 months ago

  • 1
Photo of Janosch

Janosch, Employee

  • 16 Posts
  • 9 Reply Likes
Hi Alex,
of course you can use task attributes like costs, duration, effort also in formulas to manipulate them or calculate KPIs.
In MM20 is a new button in the formula editor which allows to use task attributes in formulas. See attached screenshot.


Photo of Alex Gooding

Alex Gooding, Champion

  • 1209 Posts
  • 311 Reply Likes
Thanks Janosch. I should have explored this further.

I expected them to appear and behave as topic properties, which they don't, but they are available in formulas. As you say this means you can manipulate them directly in formulas, but you can also make them available as topic properties by writing a formula to create a topic property equal to the task attribute.
(Edited)
Photo of Tom

Tom

  • 12 Posts
  • 2 Reply Likes
Hello Alex,

the only way I see to do this with the current version MM2020 is to export and reimport via Excel.



Photo of Alex Gooding

Alex Gooding, Champion

  • 1209 Posts
  • 311 Reply Likes
Hi Tom,

It's actually quite simple. You have to write a formula using the new Task Attribute feature to create a calculated topic property, as described by Janosch in his post.

To write a calculated topic property for the General Cost, this formula is: [General cost]=GeneralCost. Then you need to right click on the property, select Define Topic properties and change the format to Currency. This property (and the formula) then need to be pasted into every relevant topic.

I've set up your example map (in English) with the formulas visible:



If you would prefer to sum the calculated properties of the costs in the central topic rather than convert them on the individual topics, the formula (on the central topic only) is [General cost]=SUM(Descendants.GeneralCost), as shown in the following example







(Edited)