How to fill a empty Field own Formula

Questions & Answers
1

hello.

image
image.png1693×1026 98.4 KB

How do i make the formula “Original Estimate / DiffDays” Calculated members?

for( from ‘baseline start date’ to ‘baseline end date’)
{
OE/DIFF = original Estimate hours / DiffDays;
}

Thanks,

2

Hi Sungjoo,

When Time dimension is used, the Original estimate is displayed on the issue created date. To override this, you can add Original estimate in a tuple with [Time].CurrentHierarchy.DefaultMember saying to ignore what current Time is on rows.

Please try the following formula that would check if current time member is between the start and end dates and then divide Original estimated hours with DateDiffDays rounded to an integer value

CASE WHEN
  DateBetween([Time].CurrentHierarchyMember.StartDate,
    [Measures].[Issue Baseline start date],
    [Measures].[Issue Baseline end date])
THEN
([Measures].[Original estimated hours], 
[Time].CurrentHierarchy.DefaultMember) /
Round(DateDiffDays(
  [Measures].[Issue Baseline start date],
  [Measures].[Issue Baseline end date]
),0)
END

Lauma / support@eazybi.com

1 Like