Hello,
I'm a bit new to report writing in Nav. Current version is 3.7. I need to create a sales analysis report with 20 columns where each column represents sales per week. I do not know the correct date formula to do this.
I'm using the customer table, "Date Filter" field and the Sales$ field.
The report will run automatically so week20 should = CW and week1 should be less 19.
This is how I'd like the report to look:
Cust No. wk1 wk2 wk3 wk4 current week!
##### Sales[1] Sales[2] Sales[3] Sales[4]...........Sales[20]
:-k
Thanks!
Cat
0
Comments
not tested, but it should work.
DateRec is a recordvariable of Subtype Date.
regards
viewtopic.php?f=5&t=10082
It Looks Like This:
http://savatage99.googlepages.com/Custo ... yMonth.pdf
It could easily be changed to do weeks instead of months - but 20 columns is going to have been real small print.
Here's a copy of the .fob
http://savatage99.googlepages.com/Repor ... yMonth.fob
Note: once done it's also easily changed to show purchases by vendor by month
http://www.BiloBeauty.com
http://www.autismspeaks.org