Calculated field shown as string

[Hemanth208]

Hi All,

I created a calculated field which is a reference type to User table. I am returning sysid of record finally. In the list view, I see the field as String for few records and for few records it is shown as Reference as intended. Any idea why this is happening?

[Dnyaneshwaree]

Hello @Hemanth208 ,

Verify that the logic you have added for returning sys ids was correct and check the data present the user table for the values shows inconsistent results.