You need to sign in to do that
Don't have an account?
pavan kumar 1864
formula firld error in report
HI,I HAVE A REQUIREMENT WHICH STATES THAT IF Account.Agreement_type__c AND Opportunity.Agreement_type__c IS NOT BLANK AND IF BOTH THE VALUES ARE THE SAME THEN RETURN 1 OR ELSE 0.
IF(NOT(ISBLANK(Account.Agreement_type__c)) AND NOT(ISBLANK(Opportunity.Agreement_type__c))
AND (TEXT(Account.Agreement_type__c) == TEXT(Opportunity.Agreement_type__c)),1,0)
I'M GETTING A ERROR AS MISSING ) AND DON'T KNOW WHETHER THIS CODES WORKS AS PER MY REQUIREMENT OR NOT.
CAN ANYONE GUIDE ME
IF(NOT(ISBLANK(Account.Agreement_type__c)) AND NOT(ISBLANK(Opportunity.Agreement_type__c))
AND (TEXT(Account.Agreement_type__c) == TEXT(Opportunity.Agreement_type__c)),1,0)
I'M GETTING A ERROR AS MISSING ) AND DON'T KNOW WHETHER THIS CODES WORKS AS PER MY REQUIREMENT OR NOT.
CAN ANYONE GUIDE ME
the idea is right.
Use && instead of AND
or
IF (
AND(
NOT(ISBLANK(Account.Agreement_type__c)),
NOT(ISBLANK(Opportunity.Agreement_type__c)),
TEXT(Account.Agreement_type__c)==TEXT(Opportunity.Agreement_type__c)
)
,1,0)
If this helps, please mark as Best Answer to help others too.
All Answers
the idea is right.
Use && instead of AND
or
IF (
AND(
NOT(ISBLANK(Account.Agreement_type__c)),
NOT(ISBLANK(Opportunity.Agreement_type__c)),
TEXT(Account.Agreement_type__c)==TEXT(Opportunity.Agreement_type__c)
)
,1,0)
If this helps, please mark as Best Answer to help others too.
Try this:
IF( AND( NOT(ISBLANK(Field1__c)), NOT(ISBLANK(Field2__c)), TEXT(Field1__c) == TEXT(Field2__c) ),1,0)
Thanks!