Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)))
Hi,
Here is the image.
Thanks..
What is the dimension / calculated dimension you have used?
May be like this:
If(Len(Trim(Dimension)) = 0, 'EMP_Not _Available', Dimension)
Hi Sunny,
This is the dimension
=if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1))
Thanks..
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)))
Thanks Sunny...awesome
=if([Transaction Type]='S',
if(Not isnull(Employee_Name1), Employee_Name1,
If(IsNull(Lawson_EmployeeName1),'Emp_Not_Available',Lawson_EmployeeName1)))
Maybe This
ALT(if([Transaction Type]='S',if(isnull(Employee_Name1),Lawson_EmployeeName1,Employee_Name1)) ,'EMP_Not _Available',) as Empfield
Recently learnt that ALT() only work with numbers. With text, the above expression will always spit out 'EMP_Not_Available'