IF( SBQQ__SubscriptionTerm__c <= 12, SBQQ__NetAmount__c , (SBQQ__NetAmount__c / SBQQ__SubscriptionTerm__c) *12 )
I would like to add an additional requirement that this formula should not calculate unless a date field on the quote object is equal to or greater than 1/1/2019.
How would I add this?
4 risposte
Try this =
IF(
SBQQ__StartDate__c >= DATE(2019, 01, 01),
IF(
SBQQ__SubscriptionTerm__c <= 12,
SBQQ__NetAmount__c,
(SBQQ__NetAmount__c / SBQQ__SubscriptionTerm__c) * 12
),
NULL
)
