The ACV formula field references the Subscription Length formula field.
'ACV_c ' Formula Field
Formula:
12 * Amount / VALUE( TEXT( Subscription_Length_Months__c ))
'Subscription_Length_Months__c ' Formula field
Formula:
IF(
OR(DAY(End_date__c) = DAY(Start_Date__c),
OR(AND(DAY(End_date__c) = DAY(Start_Date__c),
MONTH(End_date__c) = MONTH(Start_Date__c))),
DAY(End_date__c) - DAY (Start_Date__c) >= 1
),
((YEAR(End_date__c ) - YEAR(Start_Date__c)) * 12) + (MONTH(End_date__c ) - MONTH(Start_Date__c )) + 1,
CEILING((End_date__c - Start_Date__c) / 365 * 12)
)
How can I reduce the formula size? Strange thing is it saves in Sandbox but not in Production
1 resposta
Hi Serena,
I am little confused about the 2 OR statements. could you explain in words what those 2 OR statements are for
