I have setup a formula to calculate a 3 point estimate on tasks, obviously resulting in long decimal strings. How do I round the result to 0 (or any other) number of decimals? (By the way, I think I'm just missing something very obvious!)
 25 Posts
 0 Reply Likes
Posted 2 months ago
 43 Posts
 4 Reply Likes
Try ROUND in hope that MM team added this function, but has not described this in help file.
Other option would be using VB script.
Other option would be using VB script.
 25 Posts
 0 Reply Likes
Thanks, @Andrey  I've tried ROUND without luck. Not sure how to apply VB script?
 43 Posts
 4 Reply Likes
The main strategy for VB script I see in tagging target cells, then loop thought target cells calculate 3point estimate using standard VB functions (there is ROUND there) and write down the calculated value to estimate variable.
Does this make sense for you?
Does this make sense for you?
aHa!Coaching, Champion
 1192 Posts
 113 Reply Likes
What is the Type of the property that's being used to store the value of the 3 point estimate?
 25 Posts
 0 Reply Likes
aHa!Coaching, Champion
 1192 Posts
 113 Reply Likes
Try changing the Type to Integer, as in the screenshot below. It will round the number to 0 decimals.
Is this something you could use?
Is this something you could use?
 25 Posts
 0 Reply Likes
Perfect solution to my problem! Thanks @Mathieu!
It would still be great to have a round function for those times when I might need a number to say, 3 decimal places only, though.
Thanks for all the help!
It would still be great to have a round function for those times when I might need a number to say, 3 decimal places only, though.
Thanks for all the help!
Related Categories

Mindjet Maps
 203 Conversations
 35 Followers

MindManager v. 2018 for Windows
 131 Conversations
 38 Followers