I am trying to create a formula field to calculate 2 number fields into a total savings field. I am trying to accomplish this in a flow and got my formula to work but if one of the incentive values is not filled out then my total savings is blank. So I am trying to create an IF( ISBLANK statement. For example if gas incentive is blank then it would replace it with 0 and still calculate the total.
IF( AND(ISBLANK({Gas_Incentive__c}),
ISBLANK({Electric_Incentive__c})),
0,
{Gas_Incentive__c} + {Electric_Incentive__c})
답변 5개
Sorry, my bad
IF(
ISBLANK( {Gas_Incentive__c} ), 0 ,
{Gas_Incentive__c} )
+
IF(
ISBLANK( {Electric_Incentive__c} ), 0,
{Electric_Incentive__c} )
