function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion


I have 24 pairs of data combinations that originate from two pick-lists, lead source and sales type. I am trying to write a formula to display a particular rate based on these combinaties. For example:


If lead source = website & sales type = type 1 then the rate would be 0.05


As a possible solution, I was able to build another formula field thats value is the concatenation of the two fields then for the rate calculation I have a (large) case statement. However, it is >10,000 chars and thus inusable.


Any suggestions?