Order Count Where Last Week is formula 1

[Toshilap]

Hello again,
I am having another dilemma.
There is a table
_______________________________________
Report Period: Date

Orders Orders_Last_Week Year_Total
________________________________________
So I am giving user parameter to enter Report Period.

My Orders are (count of Orders_Qty by Product)

My Orders_Last_Week is what?
How do I apply that I need
(count of Orders_Qty by Product)where (Order_Date = Report_Period -7)

Please, help.

 

[lbass]

Does the user enter a date for {?ReportPeriod} or a range? If only a date, what does the date represent, e.g., the week ending this date, or what?

-LB

 

[Toshilap]

We decided to let user choose range.
It will be a week range.
I will have to display data for THE week (selected) and week prior to the selected one (here comes the problem for me).

I am strugling with CR syntax trying to make formula work.
No luck...please, help.

 

[lbass]

Use a record selection formula like:

{table.date} in minimum({?daterange})-7 to maximum({?daterange})

Then create a last week formula like:

if {table.date} in minimum({?daterange})-7 to maximum({?daterange})-7 then 1

For {@selectedweek}, use:

if {table.date} in {?daterange} then 1

Then right click on this formula in the detail section and insert a summary (sum, not count).

-LB

 

[Toshilap]

I am sure it will work. Thanks so much I will test it tomorrow. Yahoo!

 

[Toshilap]

lbass, I thank you so much, I was lost, now I am getting it slowly but surely I hope