topic Re: I want the Total value including all three types in App Development

I want the Total value including all three types

Sxbbb — Fri, 15 Nov 2024 21:39:18 GMT

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 — Thu, 22 Jun 2023 01:58:38 GMT

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 — Thu, 22 Jun 2023 02:12:24 GMT

The value came out correct, thank you very much.