Replace null dimension value with string

[nareshthavidishetty]

Hi,

In the below image i need to replace '-' with 'EMP_Not _Available' and it is an dimension and the change should reflect only that dimension alone.

[nareshthavidishetty]

Hi,

Here is the image.

Thanks..

[MK_QSL]

What is the dimension / calculated dimension you have used?

[sunny_talwar]

May be like this:

If(Len(Trim(Dimension)) = 0, 'EMP_Not _Available', Dimension)

[nareshthavidishetty]

Hi Sunny,

This is the dimension

=if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1))

Thanks..

[sunny_talwar · Accepted solution]

May be this

If(Len(Trim(If([Transaction Type]='S', If(IsNull(Employee_Name1), Lawson_EmployeeName1, Employee_Name1)))) = 0, 'EMP_Not _Available', If([Transaction Type]='S', If(IsNull(Employee_Name1), Lawson_EmployeeName1, Employee_Name1)))

[nareshthavidishetty]

Thanks Sunny...awesome

[MK_QSL]

=if([Transaction Type]='S',

     if(Not isnull(Employee_Name1), Employee_Name1,

          If(IsNull(Lawson_EmployeeName1),'Emp_Not_Available',Lawson_EmployeeName1)))

[rupamjyotidas]

Maybe This

ALT(if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1)) ,'EMP_Not _Available',)  as Empfield

[sunny_talwar]

Recently learnt that ALT() only work with numbers. With text, the above expression will always spit out 'EMP_Not_Available'