+ Start a Discussion
RajashriRajashri 

Need help with Formula

Hi,

 

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?

 

 

RoyGiladRoyGilad

Hi 

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,