Hi, I would like to rename an existing predefined measure. Is there a way to do so?
When I create a new field “Percent Escalated” with exactly the same calculation as “Issues Created”, I get different results. Percent escalated shows “Infinity%”,but the same formula in the default predefined measure gives correct results. Not sure what I am doing wrong.
You are using the correct approach. You can define a new measure and address a default measure as a formula. For example, here is how to address Issues created as a formula, place this measure name in the formula window and set a new name for the new calculated measure:
[Measures].[Issues created]
The result Infinity% typically comes from a division by 0. Please check if the formula might include this. We suggest verifying the divider is not 0 before applying the division. Here is an example report in our demo account to calculate Issues resovled%. The formula verifies if there are created issues before using this measure as a divider.
Daina / support@eazybi.com
