Need help with a formula for a custom object field

Question

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

Deepak K Anand · Accepted Answer

Like this =  IF(     AND(         ISBLANK(Actual_ECPP__c),         ISBLANK(ECPP__c)     ),     NULL,     Adjusted_Amount__c/BLANKVALUE(Actual_ECPP__c, ECPP__c) )

Steve Molis · Answer

Sara,   Show Deepak some love and hook the brother up!

Need help with a formula for a custom object field

Sales And Marketing

Verwandte Lerninhalte

Weitere Hilfe