Sum of custom Field

hello,

i want make a schedule project chart

each issue has a progress(custom Field).

Sum of issue in project divided by Issue count.
ex. “INS” project has 100 issues.
sum of the issue progress value = 94500
and then 94500 / 100 = 94.5

then, I want to fill 94.5 in the RED BOX,

how do i get these values??

thanks.

Hi,

You could create a new calculated member in “Measures” dimension using the following code:

NonZero(
Avg(
Filter(
Descendants([Issue].CurrentHierarchyMember,[Issue].[Issue]),
Not IsEmpty([Measures].[Issue Progress])
AND
[Measures].[Issues created]>0
),
[Measures].[Issue Progress]
)
)

Please choose custom formatting for that calculated measure:

Then you could select your new calculated measure instead of “Issue Progress”

Martins / eazyBI support