Skip to main content
Topics#Data ManagementPregunta de Wolfgang Red
Wolfgang Red preguntó en #Data Management
10 ago 2017, 12:11

Hi Guys, i need help!

Field: MainContract status

 

given: 

 

ParentContract_Lookup__c = MainContractNumber

 

Max_Enddate_ContractLineItem__c = MaxEnddate subcontract

 

MaxEndDate_CoreContract = Core MaxEndDate

 

I would love that: 

 

If my MainContractNumber Field is empty, then the other field (MainContract status) should also be empty.

 

AND the other three instructions should also work.

 

My solution: (with Syntax Mistakes)

 

IF (ParentContract_Lookup__c = '','' ,  

 

IF(Max_Enddate_ContractLineItem__c > ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c,

 

"correction necassary", 

 

IF(Max_Enddate_ContractLineItem__c = ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c, 

 

"OK",

 

IF((Max_Enddate_ContractLineItem__c != ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c && Max_Enddate_ContractLineItem__c < ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c), 

 

 "Attention", ""))))

 

 
2 respuestas
  1. Amit Singh (PantherSchools)
    10 ago 2017, 12:22

    Use Below Formula,

    IF (ISBLANK(ParentContract_Lookup__c),'' ,  
    		IF(Max_Enddate_ContractLineItem__c > ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c, "correction necassary", 
    			IF(Max_Enddate_ContractLineItem__c == ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c,  "OK",
    				IF(AND((Max_Enddate_ContractLineItem__c != ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c), (Max_Enddate_ContractLineItem__c <        ParentContract_Lookup__r.Max_Enddate_ContractLineItem__c)), "Attention", ""
    			    ) 	
    		    )
    		)
    	)

    Note :- Your Formula ReturnType must be Text. If not work please post error as well.

Escribir una respuesta...
0/9000