Skip to main content

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

 

@Salesforce CPQ @Quote to Payment - SalesforceCPQ&Billing

4 risposte
  1. Steven Trumble (Strum Consulting) Forum Ambassador
    17 gen 2023, 21:43

    IF(

    VALUE(TEXT(SBQQ__SubscriptionTerm__c)) >= 12,

    12,

    VALUE(TEXT(SBQQ__SubscriptionTerm__c)) * SBQQ__NetPrice__c

    )

0/9000