# Formula is not valid error

**URL:** <https://community.eazybi.com/t/formula-is-not-valid-error/13336>\
**Category:** Questions & Answers\
**Tags:** jira, calculatedmembers, mdx\
**Created:** [August 2, 2023, 5:43am UTC](https://community.eazybi.com/t/formula-is-not-valid-error/13336 "2023-08-02T05:43:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nagaraju\_T](https://community.eazybi.com/user_avatar/community.eazybi.com/nagaraju_t/32/9137_2.png) [@Nagaraju\_T](https://community.eazybi.com/u/Nagaraju_T)\
**Post date:** [August 2, 2023, 5:43am UTC](https://community.eazybi.com/t/formula-is-not-valid-error/13336/1 "2023-08-02T05:43:54Z")

</div>

Hi  
I am building a Average Age of Working Items (issues) in progress trend report.  
I have created the below reports:

**Work Items Age in Days**  
Datediffdays((  
[Measures].[Transition to status last date],  
[Transition Status].[In Progress],  
[Time].CurrentHierarchy.DefaultMember ),  
DateAddDays(Now(),1))))

**Total Work Item Age In Development**  
Aggregate( Filter(  
[Issue].[Status].Members,  
[Issue].CurrentMember.Name = “In Progress” ),  
[Measures].[Work Items Age in Days] ))

**Average Age In Development**  
IIF([Measures].[Total Work Item Age In Development] = 0, NULL, [Measures].[Total Work Item Age In Development] / [Measures].[Issues created])

However - the second report comes up with an error  
 ![Eazybi 2](https://community.eazybi.com/uploads/default/original/2X/e/e3222c93f6572aea053ecaeeb7eecd9dc364b0ba.png)

**Total Work Item Age In Development**

I have tried amending [Issue].[Status].Members, to

[Issue].[Status].Level.Members,  
[Issue].[Status].Hierarchy.Members,  
But then I don’t get any reportable data.

Aggregate(  
Filter(  
[Issue].[Status].Members,  
[Issue].CurrentMember.Name = “In Progress” ),  
[Measures].[Work Items Age in Days] )

Please Suggest

---

<div class="post-metadata">

**Author:** ![Elita.Kalane](https://community.eazybi.com/user_avatar/community.eazybi.com/elita.kalane/32/14957_2.png) [@Elita.Kalane](https://community.eazybi.com/u/Elita.Kalane)\
**Post date:** [August 3, 2023, 9:27am UTC](https://community.eazybi.com/t/formula-is-not-valid-error/13336/2 "2023-08-03T09:27:58Z")

</div>

Hello @Nagaraju_T  
​  
​Thanks for sharing your use case and the formulas you are using.

When building eazyBI reports and you need to find out a set of data based on issue properties, you should use the Descendants function which allows to iterate through every issue and the defined/filtered properties. You can learn more and see examples about descendants function here - [Descendants](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members/mdx-function-reference/descendants)  
​  
​I also suggest you to take a look at our demo account report as it seems like this is something you are looking for. You can use the same report using your own data and adjust it to your requirements,  
​[Issue days in selected status - Issues - Jira Demo - eazyBI](https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status)  
​  
​Additionally - you might find this documentation useful as well to learn more about naming conventions and ​dimensions, hierarchies and levels - [Calculated measures and members](https://docs.eazybi.com/eazybi/analyze-and-visualize/calculated-measures-and-members#Calculatedmeasuresandmembers-Namingconventions)

Best wishes,

Elita from [support@eazybi.com](mailto:support@eazybi.com)