The report below is working well, but contains all Issue Statuses. I would like to eliminate those that have a status of “Rejected”. I’m fairly new to eazyBI. I’ve read through a lot of the materials, but need some help. Thanks in advance
Hi,
The recommended solution to exclude a specific issue status from the calculation is another custom measure on top of your Total Estimated Days.
The formula is the following:
[Measures].[Total Estimated Days (SIB)]
-
([Measures].[Total Estimated Days (SIB)],
[Status].[Rejected])
This formula uses the tuple to subtract the value of specific status from the total. Please, check more about tuples in our documentation:
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/tuple
https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/calculated-measures#Calculatedmeasures-Tuples
Kindly,
Janis, eazyBI support