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
Nz([Section Total:]* 0.05)
+Nz([Section Total]*0.25)
+Nz([Unnamed 5]*0.1)
+Nz([Unnamed 6]*0.03)
+Nz([Unnamed 7]*0.12)
+Nz([Unnamed 8]*0.15)
+Nz([Unnamed 10]*0.25)
+Nz([Section Total;]*0.05)
+Nz([Section Total]*0.25)
+Nz([Unnamed 5]*0.1)
+Nz([Unnamed 6]*0.03)
+Nz([Unnamed 7]*0.12)
+Nz([Unnamed 8]*0.15)
+Nz([Unnamed 10]*0.25)
+Nz([Section Total;]*0.05)