I would like to create a formula field on my report using some fields of my report. The formula would like to create is: ((= 90%) + (=100%) * 0,2)/(< 90%)
This formula must be at the end of all rows. Anyboy knows how to do it?
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
First of all: My advise is to start using Quotas rather than using a custom field on the user object. It gives you a more solid way of tracking Sales performance. If you want to use custom fields for Quotas, I would advise to create a custom object for this, rather than use the User object. This to prevent all sorts of problems. For starters: The user doesn’t necessarily have to be the Opportunity owner.
Having said this, the answer to your question is:
Just to give you an example:
With this you will be able to report on Opportunity vs Target per user. Just create other formulas to meet your needs. Again: it makes a lot more sense to forcast and report on Opportunity owners rather than Users.