Adding running sum formulas

[MegOBytes]

Why won't a simple formula such as

{#RunSum_Vat00}+{#RunSum_Vat04}+{#RunSum_Vat07}+{#RunSum_Vat16}

not return the correct values?

The running sum formulas are set to NOT reset.

RJ Piekos

 

[lbass]

Are the individual running totals accurate? If so, this formula should work when placed in the report footer.

For further help, you would need to provide more detail.

-LB

 

[MegOBytes]

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).



RJ Piekos

 

[lbass]

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}
)

-LB

 

[MegOBytes]

its returning null for the those sums because there were no VAT (taxes) for the report period.

i understand your formula but i was wondering if there was a way to put

if isnull({#RunSum_Vat00}) then 0

somewhere in the running sum dialogue box so that it at least returns a zero.

RJ Piekos

 

[MegOBytes]

other info:

each running sum formula has an evaluate criteria that is specific to the run sum formula - as an example:


{F4211.SDLITM} = "VAT00" (for the #RunSum_Vat00 formula)

this criteria seems to work for the Vat tax that actually had data

RJ Piekos

 

[lbass]

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.

-LB