Apex Code Development You need to sign in to do that
Don't have an account?
VarunC 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__c | Detail__c | Paid__c | Entry_Date__c |
| Processed | 2/20/2009 | ||
| Processed | XYZ-001 | TRUE | 2/20/2009 |
| Processed | XYZ-004 | 2/20/2009 | |
| Processed | XYZ-005 | 2/20/2009 | |
| Processed | XYZ-002 | TRUE | 2/20/2009 |
| Processed | 2/20/2009 |
DESIRED OUTPUT:
| Status__c | Detail__c | Paid__c | Entry_Date__c |
| Created | 2/20/2009 | ||
| Paid | XYZ-001 | TRUE | 2/20/2009 |
| Processed | XYZ-004 | 2/20/2009 | |
| Processed | XYZ-005 | 2/20/2009 | |
| Paid | XYZ-002 | TRUE | 2/20/2009 |
| Created | 2/20/2009 |
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"?
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.