This is my formula in my group header (which is group by account)
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?