I created a form which has a calculated value as below:
userProfileLookup(Current User,"PreferredName")

The issue is that when we create new item, the name sometime appear as #Value! while sometimes it is working fine.
Please advise why this is happening.




