I am trying to add the results of a query together if the results meet
a certain criteria

= If
(<BO Sales Office Id>="SEUS") Or
(<BO Sales Office Id>="ATLT") Or
(<BO Sales Office Id>="DIST") Or
(<BO Sales Office Id>="DSPN") Or
(<BO Sales Office Id>="GRLK") Or
(<BO Sales Office Id>="NCAL") Or
(<BO Sales Office Id>="NCEN") Or
(<BO Sales Office Id>="NENG") Or
(<BO Sales Office Id>="NREP") Or
(<BO Sales Office Id>="PCNW") Or
(<BO Sales Office Id>="RKMT") Or
(<BO Sales Office Id>="SCAL") Or
(<BO Sales Office Id>="SCEN") Or
(<BO Sales Office Id>="#EMPTY")
Then
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="SEUS"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="ATLT"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="DIST"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="DSPN"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="GRLK"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="NCAL"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="NCEN"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="NENG"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="NREP"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="PCNW"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="RKMT"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="SCAL"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="SCEN"))+
(<BO Item Value Sales Org Curr> Where (<BO Sales Office Id>="#EMPTY"))


In our database this BO sales office ID field contains some blank
fields. For some reason, BO does not recognize these with the #EMPTY.
It give me a error when I try to do a IsNull. Why is it not adding that
empty field to the results. Please help