I am trying to do a compliance report of how many costumers of an agreement have made an order in the last year.
But I can only find the costumers who have made an order - but I need to find the percentage of how many who has bought and how many hasent bought in the last year.
Can you help me ?
20 个回答
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
A date cannot be 0 so your second IF wouldn't work. Also, this is not how you woudl write it, you'd have to write:
IF(OR(Apttus_Config2__Order__c.APTS_Billing_Date__c<= ADDMONTHS(TODAY(),-6),Apttus_Config2__Order__c.APTS_Billing_Date__c = 0),1,0)
Even though it won't work as a date cannot be 0. If you want to say that it is blank:
IF(OR(Apttus_Config2__Order__c.APTS_Billing_Date__c<= ADDMONTHS(TODAY(),-6),ISBLANK(Apttus_Config2__Order__c.APTS_Billing_Date__c)),1,0)
