Logged by Original Estimate not adding up

Questions & Answers
, ,
1

Hi,

I have the following formula which calculates the Original estimated hours by logged by:

Sum(
  --set of logged by users in selected team
  DescendantsSet([Logged by].CurrentMember,[Logged by].[User]),
  --for each user in the team look up the original estimated hours
  CASE WHEN
    ([Measures].[Hours spent],
    [Logged by].CurrentHierarchyMember,
    [Logged by].CurrentHierarchyMember) > 0
  THEN
  (
    [Measures].[Original estimated hours],
    [Assignee].[User].GetMemberByKey(
      [Logged by].CurrentMember.Key),
    [Logged by].CurrentHierarchy.DefaultMember,
    [Logged by].CurrentHierarchy.DefaultMember
  )*1
  END
)

Even though I’ve set the formatting to decimal, for some reason, it’s not adding the total. Note that I’ve grouped logged by in teams.

image
image965×304 26.7 KB

Any tip or reason why this is happening ?

Thank you

2

Hi, @Karim_Momo

Welcom to the eazyBI community.

Let’s start with the formula, there are tuples in the CASE statement.

A tuple has a restriction that only one member from the same dimension can be used.
Please remove the duplicate [Logged by].CurrentHierarchyMember.

We have special comments with annotations and one of them is for sum to show. Please read more: Calculated measures and members

The final formula should look something like this:

-- annotations.total=sum 
Sum(
  --set of logged by users in selected team
  DescendantsSet([Logged by].CurrentMember,[Logged by].[User]),
  --for each user in the team look up the original estimated hours
  CASE WHEN
    ([Measures].[Hours spent],
    [Logged by].CurrentHierarchyMember) > 0
  THEN
  (
    [Measures].[Original estimated hours],
    [Assignee].[User].GetMemberByKey(
      [Logged by].CurrentMember.Key),
    [Logged by].CurrentHierarchy.DefaultMember
  )*1
  END
)

If this is not helping, please send the report definition to support@eazybi.com

How to export report definition you can find here: Export and import report definitions

There might be a problem with calculated members in the the Logged by or Sprints dimension, which affects, the showing of the sum.

Kindly,
Ilze support@eazybi.com