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 件の回答
  1. 2月18日 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