You need to sign in to do that
Don't have an account?
whatever513
Calculate Revenue using 3 fields (including a picklist)?
I am not sure this is possible. On my Accounts Tab I would like a field for Estimated Revenue. It would be calculated using 3 different fields:
Number of Units (number input manually) x Unit Rate (number input manually) x Contract Length (number of months selected from a picklist - choices are: 36, 48, 60, 72)
Is there a formula that can be created using these 3 fields with one of them being a picklist? Any help with this is appreciated. Thank you in advance.
Use the following formula :
Number_of_Units__c * Unit_Rate__c * VALUE(Text(Contract_Length__c))
where Number_of_Units__c and Unit_Rate__c are number fields and Contract_Length__c is a picklist.
Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.