Skip to main content
Topics#Sales And MarketingSara Noorzay の質問
Sara Noorzay (PebblePost) が「#Sales And Marketing」で質問
2018年10月25日 19:12

Need help with a formula for a custom object field

I've created a formula field called Adjust Mailpieces, I want the calculation logic to be as follows

 

If Actual eCPP field is blank then Adjust Mailpieces = Adjusted Amount/eCPP

 

Otherwise

 

If Actual eCPP is NOT BLANK then Adjusted Mailpieces = Adjusted Amount/Actual eCPP
3 件の回答
  1. Deepak K Anand (‎‎‎‎‎‎Zoom Communications, Inc.)
    2018年10月25日 19:14

    Like this = 

    IF(
        AND(
            ISBLANK(Actual_ECPP__c),
            ISBLANK(ECPP__c)
        ),
        NULL,
        Adjusted_Amount__c/BLANKVALUE(Actual_ECPP__c, ECPP__c)
    )
回答を記入...
0/9000