Need Help onTricky Running Total

[mintman]

I have data like this

Zone Case Volume

AB01 DCDC 10
AB01 DCD2 10
AB01 DCD3 10
For this Total Volume should be 10 for Zone AB01

Zone Case Volume

AB01 10
AB01 10
AB01 10
AB01 DCD1 10
In this case Volume should be 30

Basice thing is I should calcumate total volume for Zone, so wat I did is I combined fields ZONE and Case in formula ZC and grouped on ZC Now did running total-- Sum on Volume, evaluate on each record and reset on chnage on group ZC.

This works fine untill all the fields under Case blank or else have values like DFG or DFE etc, problem is if I have both field value Blankdata or DFG etc,till balnk field it adds and then it resets when there is data(i dont want this) I want to continue the total.

Any ideas on this. Thanks for the help
M

 

[mintman]

Sorry forgot to mention I have to Sum the voulume only when fields Under case is constaant, even if it is blank i can sum. Problem is if there is Blank record and a data record are both combined..
Thanks.

 

[Madawc]

I'm not clear about what you're trying to do. If you are using two alternative methods of totalling, use two running totals and then check at the end which one should be used.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10