why grand totals don't show when one of the subtotals is zero?

[yehong]

I have two running totals. RunA and RunB. RunA shows the subtotal of salary for group A and RunB for group B. I have formula @GrandRunTotal that adds RunA+RunB.
Say if RunA=$0 and RunB=$45000, then my formula does not return any value. Whereas it should return $45000. If both running totals have values then it returns correct results.
Anybody has idea why the formula is just showing nothing instead of RunB's value?

 

[synapsevampire]

It's not because it's 0, it's because it's null.

A quick cheat is to select File->Report Options->Convert null value to default, but if you need to use Nulls in the report, use a formula instead of the field for doing the sum against:

If isnull({table.salary}) or {table.salary} = 0 then
0
else
{table.salary}

Now use the Running Total against this formula.

-k

 

[yehong]

It worked when I used IsNull function. Initially I was using "If{Table.Field}=0".
Thanks Synapsevampire.