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 respuestas
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
