Null value

[#1]

Hi,

I have a requirement, where i need to display the top users in a straight table. but issue here is some of the usename's are null and has userid's and in such case instead of username i have to display the user id in the table than showing null username.

Thanks in advance.

[MK_QSL]

In your script .. .use below instead of username

IF(Len(Trim(username))=0,'No Name' & [user id], usename) as username,

Now you can show it by username

[its_anandrjs]

If you dont want to show null values then use below script

if( Len(trim(username)) > 0 , userid )