EazyBI Report

Question

pp.jpg

I want to get Sum of this columns...

how to write code, to get Sum Value ??

pp.jpg

Rita YOUNES [In · Answer

Hello @Peter Ben  : I want to get the sum of custom field called Nb. of Days per Issue Type (in the table I have x=reporter and Y=Issue Type. 
Kindly advise
Rita

orgest · Answer

Hi Peter

I am using this code for Balance Value, now only the first and second row is not working correctly.

CASE WHEN NOT [Time].CurrentMember IS [Time].DefaultMember THEN
CASE WHEN [Issue].CurrentMember.Level IS [Issue].[Issue]
THEN [Measures].[Balancestart ] +
CASE WHEN 
[Time].CurrentMember IS YTD([Time].CurrentMember).Item(0)
 THEN
Sum(
{[Issue].[Issue].Members.Item(0) : [Issue].CurrentMember},
[Measures].[Credit] - [Measures].[Debit]
 )
ELSE 
Sum(
{[Issue].[Issue].Members.Item(0) : [Issue].CurrentMember},
[Measures].[Credit] - [Measures].[Debit]
  ) + Sum(
    YTD([Time].CurrentMember.PrevMember),
      ([Issue].DefaultMember, [Measures].[Credit])
        - ([Issue].DefaultMember, 
	          [Measures].[Debit])
    )
  END
  ELSE
    [Measures].[Balancestart ] +
    Sum(
      YTD([Time].CurrentMember),
        [Measures].[Credit] - [Measures].[Debit]
    )
  END
ELSE 
	  [Measures].[Credit] - [Measures].[Debit]
END

Peter Bengov · Answer

For this you would probably need to create a custom Measure. Since I'm not sure how to access PrevMember, I'll let eazyBI support to answer this one.