Hi everyone!
I hope I will find the answer here.
I have a formula field Total fee in currency that is checking whether Applied_FX__c field is blank or not, if it isn't blank then Total fee in currency = Avg_per_month__c/Applied_FX__c. Because sometime the Applied_FX__c has not value, is blank, so I want to avoid division by zero or by blank value but even with the formula below, I'm still getting the #.Error! for cases where Applied_FX__c
is blank.
IF ( ISBLANK ( Applied_FX__c ),
0,
Avg_per_month__c / Applied_FX__c )
Did I miss something in the formula?
답변 5개
Eric Praud (Activ8 Solar Energies) 
Forum Ambassador
Hi,
Make sure you select "Treat blank fields as blank" underneath the formual box in the field setup
