• #36618
    Salesforce | Aman Aman #4
    Salesforce | shariq shariq #1

    Create formula field in User Object with formula “Profile.UserLicense.Name”.
    Note: You need to copy and paste this value because it doesn’t show up in the fields drop down.

    Salesforce | Parul Parul #2

    Create a TEXT formula field on the USER object (e.g., SF License)

    In the formula section paste the following:


    Save the formula and use SF License in your reports views.


    Salesforce | Parul Parul #2

    1. Click Setup.
    2. Access Report Types:
    Salesforce Classic: Under “Build,” click Create | select Report Type.
    Salesforce Lightning: Go to Feature Settings | Analytics | Reports & Dashboards | Select Report Types.

    3. Click New Custom Report Type.
    4. In the “Primary Object” field, select Users.
    5. Enter a name, label, description, and category for your new report.
    6. Select a deployment status.
    7. Click Next, then click Save.
    8. Click Edit Layout.
    9. Under “View,” click Add fields related via lookup.
    10. Click Profile.
    11. Select User License, then click View related fields.
    12. Select Name, Status, and Total Licenses, then click OK.
    13. Click Save.
    14. Click the Reports tab.
    15. Click New Report.
    16. Click the folder (category) you saved your report to, then select your new User Licenses Report.
    17. Click Create.
    18. Under “Fields,” drag and drop Profile: User License: Name to the report preview.
    19. Click Run Report.

Viewing 4 posts - 1 through 4 (of 4 total)

Please to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials


Forgot your details?