EazyBI - Trying to get a sum of a custom field for all linked issues

[Andrew]

Hello - I am trying to get a sum of a custom field for all linked issues.  I have a custom field called "Story Points" that has been imported as a measure.  I tried the follwing code from another post, but no luck.  I am looking to sum up all of the story points that belong to a particular epic.  I get a "Formula is not valid" error:

Formula is not valid: 
Syntax error at line 4, column 5, token 'AND'

Original post:

https://community.atlassian.com/t5/Product-Apps-questions/EazyBI-calculate-sum-of-custom-field-values-for-issues-in-Epic/qaq-p/91653

Sample Code:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    AND
    [Measures].[Issues created] > 0
)
,[Measures].[Story Points]
)

Any thoughts on this?  Thanks in advance.

[Zane eazyBI Support]

Hello,

The provided formula has the wrong syntax. To make it work you may remove operand AND and use a formula like this:

Sum(
  Filter(
    Descendants([Issue].CurrentMember, [Issue].[Issue]),
    [Measures].[Issues created] > 0),
  [Measures].[Story Points]
)

Other suggestion is to validate the correct name of the measure "Story Points". When you define a formula for a calculated measure, on the right side is a list of all available measures (root members), and you may pick the measure from a list to use a precise name.

Regards,
Zane / support@eazybi.com

[Andrew]

Thank you, this worked great!