You need to sign in to do that
Don't have an account?
Amanda Jones
Write formula to run calculation only on field that does not contain a zero value
I have two currency fields on my campaigns object. If one field is calculated, by default the other is not and has a zero balance.
I need to write a formula that decides when a field is not equal to zero and then performs a calculation on that field.
Here is what I have so far:
IF(NOT(
ISBLANK(First_Time_STI_Total_Cost__c)),
First_Time_STI_Total_Cost__c-Total_Amount_Received__c,
null
)
OR
IF(NOT(
ISBLANK(Repeat_STI_Total_Cost__c)),
Repeat_STI_Total_Cost__c-Total_Amount_Received__c,
null
)
But it doesn't work. Please help.
I need to write a formula that decides when a field is not equal to zero and then performs a calculation on that field.
Here is what I have so far:
IF(NOT(
ISBLANK(First_Time_STI_Total_Cost__c)),
First_Time_STI_Total_Cost__c-Total_Amount_Received__c,
null
)
OR
IF(NOT(
ISBLANK(Repeat_STI_Total_Cost__c)),
Repeat_STI_Total_Cost__c-Total_Amount_Received__c,
null
)
But it doesn't work. Please help.
Try this..
IF(
NOT(
OR(ISBLANK(First_Time_STI_Total_Cost__c),ISNULL(First_Time_STI_Total_Cost__c))
),
First_Time_STI_Total_Cost__c-Total_Amount_Received__c,
IF(
NOT(
OR(ISBLANK(Repeat_STI_Total_Cost__c),ISNULL(Repeat_STI_Total_Cost__c))
),
Repeat_STI_Total_Cost__c-Total_Amount_Received__c,
null
)
)
Thank you so much for the response. I cannot test the formula because it won't compile. Here is the error I received: Error: Compiled formula is too big to execute (21,146 characters). Maximum size is 5,000 characters.
Is there a way to use the Case function to make it smaller?