I have a formula field that is not behaving as expected.
If Subscription Term is 12 or larger, just trying to multiply Net Unit Price by 12, and if under 12, multiply Net Unit Price by the Subscription Term.
Any help apprciated.
IF(
VALUE(TEXT(SBQQ__SubscriptionTerm__c)) >= 12,
12,
VALUE(TEXT(SBQQ__SubscriptionTerm__c))
) * SBQQ__NetPrice__c
4 risposte
Steven Trumble (Strum Consulting) Forum Ambassador
IF(
VALUE(TEXT(SBQQ__SubscriptionTerm__c)) >= 12,
12,
VALUE(TEXT(SBQQ__SubscriptionTerm__c)) * SBQQ__NetPrice__c
)