You need to sign in to do that
Don't have an account?
AAI
date formula with conditions
Hi all,
I created this formula to get a divisa number. The question is that I can´t use the operator " * " to calculate the figure. I would appreciate any idea?
IF ( BillingDate__c + Service_Term_months__c * 30 > DATE(YEAR(TODAY())+1,1,1),
IF ((NRC__c + Incremental_MRC__c )* DATE(YEAR(TODAY())+1,1,1) - BillingDate__c),
IF ( BillingDate__c + Service_Term_months__c * 30 < DATE(YEAR(TODAY())+1,1,1)),
IF(NRC__c + (Incremental_MRC__c * Service_Term_months__c),null)
Thanks,
I created this formula to get a divisa number. The question is that I can´t use the operator " * " to calculate the figure. I would appreciate any idea?
IF ( BillingDate__c + Service_Term_months__c * 30 > DATE(YEAR(TODAY())+1,1,1),
IF ((NRC__c + Incremental_MRC__c )* DATE(YEAR(TODAY())+1,1,1) - BillingDate__c),
IF ( BillingDate__c + Service_Term_months__c * 30 < DATE(YEAR(TODAY())+1,1,1)),
IF(NRC__c + (Incremental_MRC__c * Service_Term_months__c),null)
Thanks,
Hi,
Please let me know the data type for all fields which are used in formula field.
Then I will modify the formula as per your requirement.
Thanks
Deepak
Your formula seems to be incomplete (both logic as well as syntax).
I have made syntactical correction. But still this doesn't seem to be correct in terms of logic. If the above condition is true, you are checking the below condition if the second condition is true, you are checking the third condition If this is true (technically not possible because this is the opposite of first condition), you are checking fourth condition if the fourth condition is true, you are returning NULL.
This cannot be the complete logic.
Can you explain your business case a little, so that we can help you out?