+ Start a Discussion
David ZhuDavid Zhu 

Different values in custom formular field calculated in report vs User object

Hi,
I came across a weired scenario.
I have a custom formula field on User object. It is called "users division". The formula is below:
 
CASE(  upper(LEFT( Profile.Name , 2)),
            "US", "Corp",
            "SY", "GIS",
            "ET", "GIS",
            "AC", "ACP",
            "Other")
Basically, it takes the first two letters from the profile. for example, if the user profile is "System administrator", the custom field value should be "GIS" in user information. 
It works as expected in the user information.

BUT, if I create a report using "Users" report. and add my custom field to the columns. The value shows as "Other" for all "system administrators".
It means the formula calculate using different value of the profile name for system admins.
Intrestingly, users with other profile name (non standard profile) have the correct value.

User-added image

User-added image

Thanks,
David
David ZhuDavid Zhu

I modified the formula as 

CASE(  upper(LEFT( Profile.Name , 2)),
            "US", "Corp",
            "SY", "GIS",
            "ET", "GIS",
            "AC", "ACP",
             Profile.Name )
 

Then in the report, the formular field value shows "PT1" for system admins. I think PT1 is the system admin profile name before '07 update.
So, I guess the report template has bug.