I am trying to get a percentage omitting a NULL field.
My formula consist of multiple sections each equaling a percentage; however, when a section Null it isn't calculating in the total scores.
Forum Discussion
Satisfactory = 1
Improvement needed = 0
Not Applicable doesn't equal anything and shouldn't count in the percentage of that section.
Improvement needed = 0
Not Applicable doesn't equal anything and shouldn't count in the percentage of that section.