Skip to main content
John Gallagher (Bell and Howell) 님이 #Formulas에 질문했습니다

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일 오후 5: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