Sign Up ›

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
VarunCVarunC 

Formula NOT evaluating correctly ....

Hi .. here is my formula:

IF(AND(NOT(ISNULL(Entry_Date__c)), ISNULL( Detail__c )),"Created",
IF(AND(NOT(ISNULL(Entry_Date__c)), NOT(ISNULL( Detail__c ))),"Processed",
IF(AND(NOT(ISNULL(Entry_Date__c)), NOT(ISNULL( Detail__c )), (Detail__r.Paid__c)),"Paid","")))
 
.. My issue with Above Formula is that it ALWAYS return "PROCESSED" ... no other value nis returned. I could not get it right for my processing, can ANYBODY please help me out in acheiving this result for this data.
 
ACTUAL OUTPUT FROM FORMULA:
 
Status__cDetail__cPaid__cEntry_Date__c
Processed  2/20/2009
ProcessedXYZ-001TRUE2/20/2009
ProcessedXYZ-004 2/20/2009
ProcessedXYZ-005 2/20/2009
ProcessedXYZ-002TRUE2/20/2009
Processed  2/20/2009
 
 
DESIRED OUTPUT:
 
Status__cDetail__cPaid__cEntry_Date__c
Created  2/20/2009
PaidXYZ-001TRUE2/20/2009
ProcessedXYZ-004 2/20/2009
ProcessedXYZ-005 2/20/2009
PaidXYZ-002TRUE2/20/2009
Created  2/20/2009
 
Message Edited by vchaddha on  02-20-2009 09:02 AM


Lori_Lori_
 
How are the fields defined?
Entry_Date__c << date?
Detail__c         << text?
Paid__c           << checkox?
 
IF(AND(NOT(ISNULL(Entry_Date__c)), ISNULL( Detail__c )),"Created",
IF(AND(NOT(ISNULL(Entry_Date__c)), NOT(ISNULL( Detail__c ))),"Processed",
IF(AND(NOT(ISNULL(Entry_Date__c)), NOT(ISNULL( Detail__c )), (Detail__r.Paid__c)),"Paid",""))) << why does the second Detail have "__r" instead of "__c"?
 


VarunCVarunC
yes ... 
 
Entry_Date__c ==> Date
Detail__c ==> LookUp field to another Object
Paid__c ==> Checkbox Field in Detail__c object 
 
Also, though i do have sorted out, BUT not Sure why the above forumla Didn't worked, ... 
 
to make the forumla work i need to REMOVE the AND(), NOT() and ISNULL() functions and use traditional Operators, like &&, <> and Fieldname <> '' instead of ISNULL()  .... then the forumal worked ...
 
can you shed some light why I needed to replace the functions with logical operators ? Thanks.