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
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))
)