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:
Sample Code:
Sum(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
AND
[Measures].[Issues created] > 0
)
,[Measures].[Story Points]
)
Any thoughts on this? Thanks in advance.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.