Strange table selection behavior

[CreepyCatLady]

Hello. I'm having an issue with selecting values in my table. In one particular field, when I make a selection, the table continues to show values other than my selection. When I make a selection in another field that uses the exact same function for different fields, I don't have the problem. 

The problem occurs in the first image, and does not occur in the second image. The PRIMARY USER field being used for selection in the first image is calculated using

=if(HW_RESPONSIBLE_USER='<Null>', LAST_LOGGED_ON_USER,HW_RESPONSIBLE_USER)

And the PRIMARY USER NAME field used for selection in the second image is calculated using 

=if(HW_RESPONSIBLE_USER_NAME='<Null>', LAST_LOGGED_ON_USER_NAME,HW_RESPONSIBLE_USER_NAME)

The "PRIMARY USER" field is calculated using =if(HW_RESPONSIBLE_USER='<Null>', LAST_LOGGED_ON_USER,HW_RESPONSIBLE_USER)

The "PRIMARY USER NAME" field is calculated using =if(HW_RESPONSIBLE_USER_NAME='<Null>', LAST_LOGGED_ON_USER_NAME,HW_RESPONSIBLE_USER_NAME)

Why is this happening?

[abhijitnalekar · Accepted solution]

Hi @CreepyCatLady ,

Please try if statement like below

if(isnull(HW_RESPONSIBLE_USER_NAME)<0,

LAST_LOGGED_ON_USER_NAME,HW_RESPONSIBLE_USER_NAME) as PrimaryUSerName

****************************

if(isnull(HW_RESPONSIBLE_USER)<0, LAST_LOGGED_ON_USER,HW_RESPONSIBLE_USER))

If this not works then likes to understand the datamodel