I am trying to take the Posting Date for the current year and convert it to a Weekly Date (the weekly date will always start with a Monday...I think I figured this part out using the function 'BOW') Then I want to sum invoice dollars across by the Weekly Date...the dollars need to be cumulative.
Is there an easy way to do this???
it should look like this..the numbers in the parentheses represents the amount in the next week so you should add the prior YTD week total to the Next week for a new YTD total :
2011/01/03 2011/01/10 2011/01/17
8,000 (-2,000) 6,000 (+3,000) 9,000

This message has been edited. Last edited by: Kerry,

how about this


DEFINE FILE XXX
BOWDATE/YYM=DATEMOV(POSTINGDATE,'BOW');
END
TABLE FILE XXX
SUM WHATEVER
COMPUTE RTOTAL=WHATEVER+RTOTAL;
BY BOWDATE
ON TABLE HOLD
END
TABLE FILE HOLD
SUM RTOTAL WHATEVER
ACCROSS BOWDATE
END


not sure about the parenthis

quote:

TABLE FILE HOLD
SUM RTOTAL WHATEVER
ACCROSS BOWDATE
END

Frank,
Looks great...:-)
Thanks so much..!!!!