Include Null value and exclude particular value in set analysis

[bbastro1106]

Hi,

I was trying to sum up a field "PO total Units".  

i used formula like the following:

Sum( {$<[PO Line Status Code] -={9}>} [PO Total Units])

However, under the PO line status code, there are value like "-" (Null) which i found all those number not sum up with this formula.

Is there anyone can help with this?  I do not want to add any flag into my script at this stage, i would like to include this in the expression formula.

[jonathandienst · Accepted solution]

The set expression works like a manual selection and you cannot select nulls directly. There are several workarounds, such as NULL AS VALUE or a flag field. Or just a simple addition to the expression:

Sum({$<[PO Line Status Code] -= {9}>} [PO Total Units]) +
Sum(If(IsNull([PO Total Units])))

[bbastro1106]

Thanks, that's work!