Working with a customer who targets their team in three ways:
- Number of appointments (events) per week
- Number of calls per week
- 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:
- Any clue as to why my formula isn't working?
- Any bright ideas on how I can solve the revenue targets conundrum?
Thanks in advance for your awesomeness!
5 respuestas
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?