Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, how do i get Data from 7 days back?
So for example if i sum(Price)
I want it to show price for today, the 7th, 6th, 5th, 4th, 3th and so on..
Can i make it in a variable??
create a variable
vToday= today()
sum({<Year=,Date={">=$(=date(vToday-7,'MM/DD/YY'))"}>}Price)
Trie with this.
Regards.
create a variable
vToday= today()
sum({<Year=,Date={">=$(=date(vToday-7,'MM/DD/YY'))"}>}Price)
Trie with this.
Regards.
that works - What is doing the rolling back? is it 'MM/DD/YY' which express that it should roll back? or how come i have to specifiy what date format it is??
No i put 'MM/DD/YY' as example.. you can change to your format.
yo say 7 day from today in (vToday-7 and you say that it can be >=...
if today is 08/02/2013.. today -7 is 01/02/2013 then you tell that will be >=..
sorry about my english..
Hope it helps you.
it worked - i just wanted to understand why it worked:) But i think i got the picture. Thankyou very much