Skip to main content

We want it to check true when any of the following are true. Collectively this is not working, but when we tried each condition by itself, it did work.

IF(

OR (

 

( SBQQ__CustomerAmount__c > 849999),

 

(TEXT( SBQQ__PaymentTerms__c ) <> TEXT( Default_Payment_Terms__c )),

 

(Click_and_Collect_BU_Margin2__c < 0.25),

 

(Heritage_BU_Factory_Margin2__c < 0.25),

 

(Manual_Approval__c = TRUE),

 

(Quantity_of_Quote_Line_Approval_Needed__c > 0),

 

(Service_BU_Gross_Profit_Percent__c < 0.4)

 

),TRUE,FALSE)

1 respuesta
  1. 18 feb, 17:20

    Hello@John Gallagher

    try,

    OR (

    SBQQ__CustomerAmount__c > 849999,

    TEXT( SBQQ__PaymentTerms__c ) <> TEXT( Default_Payment_Terms__c),

    Click_and_Collect_BU_Margin2__c < 0.25,

    Heritage_BU_Factory_Margin2__c < 0.25,

    Manual_Approval__c = TRUE,

    Quantity_of_Quote_Line_Approval_Needed__c > 0,

    Service_BU_Gross_Profit_Percent__c < 0.4

    )

0/9000