Skip to main content
Hello,

 

I need to add another IF in an existing formula field with IF.

 

In a field Total Amount I need to integrate the particularity that if the pricing method is Block the price must multiply with the effective quantity.

 

The Formula is :

 

IF(

 

AND(NOT(ISBLANK(SBQQ__SegmentQuantity__c)),SBQQ__SegmentQuantity__c!=0),

 

(SBQQ__SegmentQuantity__c * SBQQ__NetPrice__c),

 

( SBQQ__Quantity__c * SBQQ__NetPrice__c))

 

and I would like add : IF(ISPICKVAL(SBQQ__PricingMethod__c, 'Block'), the calculation must be = ( SBQQ__QuoteLine__r.SBQQ__EffectiveQuantity__c * SBQQ__NetPrice__c )

 

I tried to insert the 1rst formula in tha wrong part but the calculation is wrong.

 

Thank you for your help
4 réponses
  1. 22 avr. 2021, 15:39
    Hi Delphine, 

     

    Please try this...

    IF

    (

    AND(NOT(ISBLANK(SBQQ__SegmentQuantity__c)),SBQQ__SegmentQuantity__c!=0),

    (SBQQ__SegmentQuantity__c * SBQQ__NetPrice__c),

    IF(ISPICKVAL(SBQQ__PricingMethod__c, 'Block'),

    (SBQQ__QuoteLine__r.SBQQ__EffectiveQuantity__c * SBQQ__NetPrice__c ),

    (SBQQ__Quantity__c * SBQQ__NetPrice__c))

    )