We currently have a dependent picklist on an OLI field.
Controlling = ProductStage
Dependent = ProductProbability
We have a separate OLI field called "Forecasted Revenue" which needs to calculate the forecasted revenue PER OLI - as we have multiple OLI's on one Opportunity we cant reply on the Opportunity Stage and Probablility fields for forecasting.
We need the forumla behing the Forecasted Revenue field to be:
OLI Total Price * ProductProbability. Because ProductProbability is a picklist I am struggling with the formula. At present I have the below (0,10,30,60,90 & 100 are the available values for this piclist field):
IF(
OR(
ISPICKVAL(ProductProb__c, "0"),
ISPICKVAL(ProductProb__c, "10"),
ISPICKVAL(ProductProb__c, "30"),
ISPICKVAL(ProductProb__c, "60"),
ISPICKVAL(ProductProb__c, "90"),
ISPICKVAL(ProductProb__c, "100")
)
* TotalPrice)
This is returning the error of "Error: Incorrect parameter type for operator '*'. Expected Number, received Boolean"
Does anybody have any ideas what the error message means and how I can fix this?
Thank you in advance!
3 answers
Hi Ella, The formula will be as below
VALUE(BLANKVALUE(TEXT(ProductProb__c),0))*(TotalPrice/100)
or alternatively as below
CASE(ProductProb__c,
"10",0.1,
"30",0.3,
"60",0.6,
"90",0.9,
"100",1,
0)*TotalPrice
