+ Start a Discussion

Need help with Formula



i am trying to design the formula, If Quantity is 500 or 400 then pick "true value1" and if Quantity is 300 and Total>0 then pick "true Value1" but if Quantity is "300" and if total=0 then pick "true value 3"  otherwise pick "else value"


How/where can i write the statement "if Quantity is "300" and if total=0 then pick "true value 3"?


How can i handle this?  is there any  way available in salseforce?



IF(ISPICKVAL(Quantity , "500") || ISPICKVAL(Quantity, "400")   || AND(Total__c>0,ISPICKVAL(Quantity  , "300")) , “true value1”, “else value”)


also i am getting the below error for above formula


Formula(s) that reference this field are no longer valid: Compiled formula is too big to execute (5,017 characters). Maximum size is 5,000 characters


Why so?Can anyone please help?





I general you need to solve this by simplify the logic expression in your formula, or implement some of the logic using workflows or apex.


I hope it helps,