Skip to main content
Hi Salesforce Gurus, I need your help.

 

Working with a customer who targets their team in three ways:

  1. Number of appointments (events) per week
  2. Number of calls per week
  3. Annual Revenue Target

They are on professional edition so obviously a lot of functionality is limited and I need to keep it simple.  

 

So for calls and appointments I have created target fields on the User record and then fields on tasks and events to pull that data through using a very basic formula i.e. $User.Appointment_Target_c however despite both fields being number fields the value being returned is 0 even though the original field has a number in it.  I was then planning to use the Max summary on reports to review number of records vs target.

 

Secondly I was planning to use SteveMo's opportunity types solution to log targets (Quotas) however for this org it is really messy as they already have 9 opportunity types and if I got that far, they don't have bucket fields for the reports.  I could potentially add the revenue targets to the user as well however this would only give a very basic solution as ideally they need to report on progress to target monthly, quarterly and YTD.

 

Have also looked at a couple of apps to solve the problem, but A they don't have a budget for this and B lots of them don't work with professional.

 

So 2 questions:

  1. Any clue as to why my formula isn't working?
  2. Any bright ideas on how I can solve the revenue targets conundrum?

Thanks in advance for your awesomeness!

5 risposte
  1. 5 ott 2017, 13:48
    1. Don't use the $. This is a system based field and is therefore referencing the Target Value on the User viewing the record (Your User). Instead you're formula will be something like: Owner:User.Appointment_Target__c so that's it's always specific the Assigned User's Target regardless who views the record.

     

    2. So are you saying based on a combination of User and Opportunity Type, you need to return a Target Value but then there are multiple Targets values based on the timeframes - Monthly, Quarterly, YTD? Could you assign each User a Number and that number just be an indicator as to which Target(s) apply to them, then use a formula in a report to avg that Number and assign the Target accordingly?