Apex Code Development You need to sign in to do that
Don't have an account?
AGFlem Nested IF(AND(ISPICKVAL())) vs CASE
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?