global numberVar nUsage :=0;

 

this is my formula in my details section

global numberVar nUsage :={BI_INTERVAL_RDGS.BI_RDG}-(if nextisnull({BI_INTERVAL_RDGS.BI_RDG})then{BI_INTERVAL_RDGS.BI_RDG}
else next ({BI_INTERVAL_RDGS.BI_RDG}));
nUsage;

Problem is my group is not setting back to zero it is subtracting the RDGS from the next record.

 

example:

Account          Date           RDG           Usage

1001           9-24-2009    59927            9

                   9-23-2009    59918           10

                   9-22-2009    59908           8

                   9-21-2009    59900          54555 this is where it subtracts RDG

                                                                       from next record

1002          9-24-2009     5345             1  It took my 59900-5345=54555

but odd thing is it shows like this for each account on my report but on the drill down of a particular account number it shows it reset to zero. I need to use the report and not the drill downs.

Can you help?

 

 

Thanks so much.