ISEmpty Logical Expression

Questions & Answers
1

Our Admins have created a new field for SLAs as translation of the english names.

The old name is ‘Time to resolution Elapsed hours’ the new name is ‘Lösungszeit Elapsed hours’.

Now I´m trying to create a calculated measure that displays the old value when is not empty, else should the new value be displayed.

Im trying this formula :
IIf( IsEmpty([Issue].CurrentHierarchyMember.get(‘Lösungszeit Elapsed hours’))=‘true’ , [Issue].CurrentHierarchyMember.get(‘Time to resolution Elapsed hours’)
, [Issue].CurrentHierarchyMember.get(‘Lösungszeit Elapsed hours’) )

But following error is being displayed:
image

What else an I do to display both values in the same column (calculated measure) ?

Many thanks in advance

2

@AntonBDR

Try this formula:

IIf( 
IsEmpty(
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours')
), 
[Issue].CurrentHierarchyMember.get('Time to resolution Elapsed hours'),
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours') 
)

Martins / eazyBI team

3

Hi @martins.vanags , when using your formula I get following error message:

image
image1300×110 15.6 KB

Thanks

4

Try using Case structure:

CASE WHEN
IsEmpty(
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours')
)
THEN
[Issue].CurrentHierarchyMember.get('Time to resolution Elapsed hours')
ELSE
[Issue].CurrentHierarchyMember.get('Lösungszeit Elapsed hours') 
END

Martins / eazyBI

5

Thanks @martins.vanags , that worked!

6

Hi,
If we have three levels comparison, how to achieve this, i tried below but the results are not accurate

CASE
WHEN
not IsEmpty(([Measures].[Estimated Efforts Impact (Hrs. / Year) with cf closed date],
[Time].CurrentHierarchy.DefaultMember))
THEN
[Measures].[Estimated Efforts Impact (Hrs. / Year) with cf closed date]

ELSE
CASE
WHEN
not IsEmpty(([Measures].[Estimated Efforts Impact (Hrs. / Year) with revised target date],
[Time].CurrentHierarchy.DefaultMember))
THEN
[Measures].[Estimated Efforts Impact (Hrs. / Year) with revised target date]

ELSE

[Measures].[Estimated Efforts Impact (Hrs. / Year) with planned target date]
END
END

7

@nagashankarp
Please contact eazyBI support and provide your report defintion.
I find it strange that you compare the results with Time DefaultMember and then return the same emasure without Time Defaultmember.

And it is important to understand where and how you use “Time” dimension in your report as well as what checkboxes you selected for all 3 fields in the import options page.

Martins // eazyBI support.