ZanaSkenderi1

3 years agoQrew Member

# Summary field used in a formula, need to return 0 to blank values

Hi,

I have a summary formula of a checkbox to give me a count, in the parent table. I am then taking that field and dividing it with itself. In turn trying to use the formula in a summary formula of a report. but if that particular person has a blank value, it does not work in the formula. I have figured out the error is occurring because it is not calculating the blank as zero. Any help with this formula would be greatly appreciated. I maybe think I need to do the blanks as zeros in the summary formula but not sure how to do it there.

This is the formula field that I need to treat blanks as zeros - [Extensive Logged Report Types]/[Extensive Logged Report Types]

This is the summary formula of the summary report - (((([Number of Charts]-[# of No Info/Search Fee (tot)]-([Extensive 1 Calculation (tot)]))/([Number of Charts])*0.03)*([Number of Charts])))

thank you for your help

------------------------------

Zana

------------------------------

I have a summary formula of a checkbox to give me a count, in the parent table. I am then taking that field and dividing it with itself. In turn trying to use the formula in a summary formula of a report. but if that particular person has a blank value, it does not work in the formula. I have figured out the error is occurring because it is not calculating the blank as zero. Any help with this formula would be greatly appreciated. I maybe think I need to do the blanks as zeros in the summary formula but not sure how to do it there.

This is the formula field that I need to treat blanks as zeros - [Extensive Logged Report Types]/[Extensive Logged Report Types]

This is the summary formula of the summary report - (((([Number of Charts]-[# of No Info/Search Fee (tot)]-([Extensive 1 Calculation (tot)]))/([Number of Charts])*0.03)*([Number of Charts])))

thank you for your help

------------------------------

Zana

------------------------------