Yes, they appear to be working. Only 1 running sum has an actual sum (#RunSum_Vat16), the other three return nothing as in not even a zero (which i formatted for).
In what sense are they working if they are returning nulls?
Anyway, change your formula to this:
(
if isnull({#RunSum_Vat00}) then
0 else
{#RunSum_Vat00}
) +
(
if isnull({#RunSum_Vat04}) then
0 else
{#RunSum_Vat04}
) +
(
if isnull({#RunSum_Vat07}) then
0 else
{#RunSum_Vat07}
) +
(
if isnull({#RunSum_Vat16}) then
0 else
{#RunSum_Vat16}
)
I'm not sure what is null in the case where nulls are returned. If the field you are summarizing is null, then replace that with a formula that contains a null check. That is the only place a null check will make any difference.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.