A third field needs the following to happen. It should equal the Opportunity amount roll up field if the adjusted field is blank. If the adjusted field is not blank then this should be the amount in the field.
This is my formula:
IF(
(ISBLANK( Adjusted_MRR__c )),
(Closed_Won_Opportunity_s__c) ,
(Adjusted_MRR__c)
)
When the Adjusted_MRR__c is blank my field comes up $ 0.00 instead of the Closed_Won_Opportunity_s__c amount. But When the Adjusted_MRR__C is not blank then this amount shows up.
Why is my Closed_Won_Opportunity_s__c amount not showing up??
답변 2개
How about this =
IF(
BLANKVALUE(Adjusted_MRR__c, 0) = 0,
Closed_Won_Opportunity_s__c,
Adjusted_MRR__c
)