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.