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
Try this
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.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)