You need to sign in to do that
Don't have an account?
Salesforce 283
Can you explain the formula field?
IF( Cancelled__c ,'Cancelled',
IF(Amount_Due__c = 0, 'Paid',
IF (OR((Amount_Due_Remaining__c <= 0),(Open_Balance__c + Amount_Due_Remaining__c) <= 0), 'Paid',
IF(Amount_Paid__c > 0,IF( Amount_Due_Remaining__c >0, 'Paid Partial','Paid'),'Open'))))
IF(Amount_Due__c = 0, 'Paid',
IF (OR((Amount_Due_Remaining__c <= 0),(Open_Balance__c + Amount_Due_Remaining__c) <= 0), 'Paid',
IF(Amount_Paid__c > 0,IF( Amount_Due_Remaining__c >0, 'Paid Partial','Paid'),'Open'))))
this says..
if Cancelled__c chcekbox is true than assign Cancelled else check if Amount_Due__c ==0 then paid else chck if Amount_Due_Remaining__c <= 0 or Open_Balance__c + Amount_Due_Remaining__c) <= 0 then Paid else check if Amount_Paid__c >0 then check IF( Amount_Due_Remaining__c >0, then 'Paid Partial'else'Paid' else open
summary:
please check and let me knwo if it helps..
Thanks,
Sandeep
All Answers
this says..
if Cancelled__c chcekbox is true than assign Cancelled else check if Amount_Due__c ==0 then paid else chck if Amount_Due_Remaining__c <= 0 or Open_Balance__c + Amount_Due_Remaining__c) <= 0 then Paid else check if Amount_Paid__c >0 then check IF( Amount_Due_Remaining__c >0, then 'Paid Partial'else'Paid' else open
summary:
please check and let me knwo if it helps..
Thanks,
Sandeep