How to remove the hiphen value and get blank space in straight table?

[tahreen371]

Hello All,

When i apply this condition -- =if(len(Business_Partner)='0',' ',Business_Partner) to Column Business_Partner it works and gives me blank spaces with the colour code but when applied to P_Name or User_Name Column it fails and also tried with the below conditions as well and still No help.

=if(len(trim(User_Name))<>0,User_Name,'NA')

//=if( User_Name = 0,1,if(ISNULL(User_Name) OR LEN(User_Name)=0,1,User_Name))

//=if(isnull(User_Name),'0',User_Name)
//=If(Len(Trim(User_Name))='0',' ', User_Name)

Can anyone Plz assist on this? Plz refer the Screenshot.

Thanks & Regards

[gn_marvs1989]

Try:

=alt(Trim(User_Name),'NA')

[tahreen371]

No that doesn't help...its still the same

[gn_marvs1989]

Can you provide us the app with data?