would really appreciate some help with the following.
I have 3 sets of data to work with here. Purchase, Stock and Sales.
The report i am working on gathers information about stock available currently and stock due in. That all works perfectly.
Now i need to include sales over the last 7 days.
From ORDRTRXS.REQ_DEL_DATE, is today or within last 7 days i would like to sum the total of WGT_CONFIRMED. The date format seems to be YYYY-MM-DD.
My thought process is to have a second selection criteria with a formula to suit, then summarise the total in each group for the products selected.
Can anyone give me some advise on this as dates is not something i have tried to work with in Crystal before.
Thanks in advance
At first a tried various formula but kept returning errors.
Graham Dolman is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.