I am having some trouble with a formula,
What i want to do is if trailer for example is selected from my picklist, i then want 2.50 to appear in my display field that is it, i am not sure if there is an easier way of doing this or if i am close to getting it right any help would be much appreciate i am open to idea if anyone has a better way of doing this also Thanks Jay :P
CASE(TEXT(Collection_Method__C),
'Trailer',2.50,
'Depot Van',3.0,
'Delivered In',2.0)
*
Value(text(Base_Rate_Test__c))
9 Antworten
Then this should really be all you need, I was getting caught up with the multiplication, not realizing it was irrelevent. I forgot the comma after the 2.0 so that explains the error. This should give you what you need, if you add more values just keep following the format.
--KC
CASE(
Collection_Method__c,
"Trailer",2.50,
"Depot Van",3.0,
"Delivered In",2.0,
0)
