You need to sign in to do that
Don't have an account?
WelcomeWagon
S-Control formula question
I have a picklist of data. I need to use that picklist to populate a non-text field. Wondering if S-Control can do that - and what the formula would look like.
Here is the data I am using as an example:
I have a total sale payout field which is a currency formula field.
Using that amount in conjunction with the following chart it yields the payout amount. I need the payout amount field to be a summary field in the Salesforce reports (meaning it can be totaled) so it cannot be a text picklist as I have it set up now. I would like to use an S control to read the net revenue value selection that I enter and generate the payout amount into a non-text field. Any chance of that? I am not a Salesforce guru - so if this makes no sense - let me know. The chart is much more extensive than the one below - but it gives you an idea.
Net Revenue Amounts (per appointment or hot lead) |
$ Payout |
$0 - $500 |
$5 |
$501 - $1,000 |
$15 |
If I have got your question right,I think instead of using an S-Control,this problem could be solved using a regular formula field like
CASE (Net_Revenue_Amounts__c , "$0 - $500", 5, "$501 - $1,000",15,0)
Kaushik