Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to get the sales of the last 23.5 months (705 days)
This is what I have come up with so far:
sum({<Accumulator_Type={'BILLED','RETAIL'},[Transaction_Date.autoCalendar.Date]={'>=$(=Date(today()-705,&Chr(39)&DD-MM-YYYY&Chr(39)&))'}>}Value-Tax)
The problem is that when I change the number 705 I get the same amount of sales although I shouldn't.
Can anyone help?
Kind Regards
George
Try this
Sum({<Accumulator_Type = {'BILLED','RETAIL'}, [Transaction_Date.autoCalendar.Date] = {">=$(=Date(Today() - 705, 'DD-MM-YYYY'))"}>} Value-Tax)
Try this
Sum({<Accumulator_Type = {'BILLED','RETAIL'}, [Transaction_Date.autoCalendar.Date] = {">=$(=Date(Today() - 705, 'DD-MM-YYYY'))"}>} Value-Tax)
Thanks. I tried it but get 0s everywhere
Can you share the script for your Derived Calendar?
You are right. It worked. I just had to change the format of the date from DD-MM-YYYY to DD/MM/YYYY