+ Start a Discussion
TheLearnerTheLearner 

Regarding amending forumla field

HI Experts,

I need to update a forumala field which is like this.

Date_Assessed_Rejected__c is null  then i need do " IF Date Assessed/ Rejected = NULL Then 
(12 + (“Total Days on Hold”)) – (Today() - Date Application Submitted) 
[where the result is a whole number]
ELSE
(12 + (“Total Days on Hold”)) – (Date Assessed/ Rejected - Date Application Submitted) [where the result is a whole number]"

this is my  existing forumla: (12 + Total_Days_on_Hold__c ) - ( TODAY() - Date_Application_Submitted__c ),

Im confused how to amend this one , could you help me out please
Best Answer chosen by TheLearner
KaranrajKaranraj
Try the below one
IF(Date_Assessed_Rejected__c == NULL,
(12 + Total_Days_on_Hold__c ) - ( TODAY() - Date_Application_Submitted__c ),
(12 + Total_Days_on_Hold__c ) - ( Date_Assessed_Rejected__c - Date_Application_Submitted__c ))

 

All Answers

KaranrajKaranraj
Try the below one
IF(Date_Assessed_Rejected__c == NULL,
(12 + Total_Days_on_Hold__c ) - ( TODAY() - Date_Application_Submitted__c ),
(12 + Total_Days_on_Hold__c ) - ( Date_Assessed_Rejected__c - Date_Application_Submitted__c ))

 
This was selected as the best answer
TheLearnerTheLearner
HI Karan,

IT workign fine. thanks