Running Totals

[dBjason]

Hello,

I have a running total which is set to calculate a sum of records when another detail value (Released) is 'F'. Formula workshop for the running total looks like this:

{s_BondTracking;1.Released} = 'F'

It works great on everything with one exception. One group has all of it's detail Released fields set to 'T' (so no calculations are performed at all). So when the group total prints, it doesn't display. I'd like it to display '$0.00' instead of blank. How can I do this?

Thanks in advance,
Jason

 

[lbass]

Try replacing the running total {#rt} with a formula:

if isnull({#rt}) then 0 else {#rt}

-LB

 

[dBjason]

Thanks! I'll give it a shot.