You need to sign in to do that
Don't have an account?
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?
Hi Rajashri,
Regarding your question -
How/where can i write the statement "if Quantity is "300" and if total=0 then pick "true value 3"?
You wrote the answer below it:
IF(AND(ISPICKVAL(Quantity , "300"),Total__c=0),"true value 3", “else value”)
So you are on the right track there.
As for the formula:
Since you are getting "Compiled formula" exception - I am guessing the "Total__c" field is a formula as well becouse I don't see in your code 5000+ chars.
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,