Hi,
I'm attempting to write a mingle query that displays the cost of each feature being developed. I have succesfully created an aggregate query that groups development time based on the feature each card belongs to, however I can not perform the required calculation to generate a dollar amount for each feature. I have looked at 2 appraoches:
1. Perform the calculation in MQL using a Project Variable containing the hourly dollar amount:
Select 'Dev Hours' * ('Dev Rate')
PROBLEM: MQL does not appear to currently support math functions.
2. Use a formula on each card to perform the dollar amount calculation:
PROBLEM: Formulas can not use project level variables.
To work around this I am able to hard-code the $value into each formala used within a card, however this is less than ideal given we want to perform many calculations on various card level values to generate more reports. Does anyone know of another way to acheive these calculations using project level variables?
If this is not possible, I would recommend adding a feature request for the ability to use project variables in formulas.
Thanks,
Adam.
MQL/Formulas and Calculations with Project Variables
Comments
4 comments
Hey Adam
1. You're correct Mingle does not support mathmatical functions in MQL. This plugin macro however, may be of interest to you though as this supports basic arithmetic expressions comprised of MQL statements.
2. We plan to support project variables in formulas soon. Please see this feature request.
Thanks
- Suzie
Suzie, are there plans to support math in functions? I was just working on creating a table that would tell me a list of tasks that were running over their estimate, using something like where 'Work Estimate' > TODAY-'Reporting Dev begun', but obviously this failed because that date arithmetic isn't supported. And I'm assuming you can't use macro results inside of other macros/table definitions, right?
Hi Chris
There are no immediate plans to add arithmetic natively in MQL or our macros. You can however, use the formula properties to do date arithmetic such as TODAY - 'Reporting Dev begun'. The resulting formula value should be a number which can be compared to "Work Estimate' using the <> operators.
Finally, if this does not meet your requirements, it might be worthwhile adding this request to the Calculator macro I mentioned in my previous post as I understand they may be continuing development on that macro and they may be able to add something to help you before we would.
Thanks Suzie
We have a need for performing basic math operators on property values in MQL as well. Looking at the plug-in macro mentioned above, it does not work cross-project.
I'm trying to build a Mingle project that provides statistics across many other Mingle projects. Something as simple as computing 'effort remaining' as the difference between 'estimate' and 'actual-to-date' is not currently possible.
Please sign in to leave a comment.