I need your help on below issue.
I have a report, returning the Billing Date and the quantity and I created my own variable KE Wk Range; basically adding 7 days to the billing date.
Now I want to see the total quantity between these days.
My report is showing the billing dates, the KE Wk Range as dates.
I am adding below, however I am getting the total qty and not only the quantity for the next 7 days for each billing date record.
=Sum([NR Tot Qty]) Where ([Billing Date] Between ([Billing Date]; [KE Wk Range]))
Could you please advise here?
Flooo (BOB member since 2013-01-23)