I created a custom object name Subject_Obligations__c and in this object I have 2 lookup fields name Judgment__c and Loan__c. I also have a checkbox (formula) field Client_Designation__c with the formula below
IF( ISBLANK(Judgment__c) , Loan__r.Client_Designation__c , Judgment__r.Client_Designation__c )
Also, in the Judgment__c custom object I have a currency field Amount__c
and in the Loan__c field I have a currency field Client_Initial_Value__c.
now here is my question, I want to create a new fomula field name Obligation Value where if
Client_Designation__c in the Subject_Obligations__c object = FALSE nothing will happen, but if Client_Designation__c = TRUE. display the currency from Amount__c if it is from Judgment__c or currency from the Client_Initial_Value__c if it is from Loan__c.
I will be waiting for your assistance, thank you
2 answers
Try this:
IF(Client_Designation__c,
IF(ISBLANK(Judgement__c),
IF(ISBLANK(Loan__c),NULL,Loan__r.Client_Initial_Value__c),
Judgment__r.Amount__c)
,NULL)
I am not exactly sure how you are determining which one to use Loan or Judgement. This formula assumes that you will only populate one at a given time, but if both are populated then use the Judgement Amount first.
