I want the Total value including all three types

[Sxbbb]

I have field : TypeStatus

The value can usually be obtained from the code :

Result :

value came out correct But I want the Total value including all three types, 'OUTER' and 'AFTER_PRESS' and 'PLATE_PANEL'. 

I tried the code but the value is incorrect

Result but the value is incorrect  : 

I want the Total value including all three types, 'OUTER' and 'AFTER_PRESS' and 'PLATE_PANEL'. 

[rwunderlich · Accepted solution]

When the "+" operator is used, a null value will cause the entire result to be null.  The more robust approach is to use RangeSum() instead of "+". 

RangeSum(Sum(...). Sum(...), Sum(...)

-Rob

[Sxbbb]

The value came out correct, thank you very much.