You need to sign in to do that
Don't have an account?
David 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:
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.
Thanks,
David
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.
Thanks,
David
I modified the formula as
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.