Loading
Feature Disruption - Service Cloud VoiceRead More
Feature degradation | Gmail Email delivery failureRead More
Sales Performance Management
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            rank

            You are here:

            1. Salesforce Help
            2. Docs
            3. Sales Performance Management

            rank

            Compares a list of filtered numbers that represent rep metrics in Salesforce Spiff, such as monthly attainment, and returns a ranking relative to the rest of the list. This function doesn't break ties and awards the same ranking to all numbers that tie.

            Required Editions

            Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience
            Available in: Enterprise, Unlimited, and Developer Editions
            Available for an additional cost in: Professional Edition with Web Services API Enabled

            Syntax

            rank(target, filter, rank_by)

            Arguments

            Argument Required? Description
            target Required The field or object that you want to rank.
            filter Required A data filter that specifies the data that you want to use for ranking.
            rank_by Required The criteria for sorting and ranking the filtered data.

            Example

            Create a rollup data filter named AE_Leaderboard, based on the User object, that returns the users from different AE teams. Rank users in this data filter by the output of the LeaderboardMonthlyAttainment calculation.

            =rank(user, AE_Leaderboard, LeaderboardMonthlyAttainment)

            By default, this function's return ranking sorts data from lowest to highest. If you sort five users by monthly attainment, the rep with the highest attainment is ranked fifth.

            To invert the ranking results so that the rep with highest attainment is ranked first, use the output of the rank() function in another formula. If you're sorting five users, maybe you have another calculation, Total_AEs, that counts the number of users, subtracts the rank, and adds 1.

            =Total_AEs - rank(user, AE_Leaderboard, LeaderboardMonthlyAttainment) + 1
            The rank function used in a formula to invert the default ranking
             
            Loading
            Salesforce Help | Article