My calculation for % is resulting in #NUM! and I need for it to result in 0% if the calculation results in 0. This (I hope) will enable me to group and get an average % in a report. Does anyone know how I can do this?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.