Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to present my sales statistics in a straight table the past 12 months...
Which is the best way to do that using set analysis??
I have this year as a default selection in my document.
sum({$<MyYear={$(=Only(MyYear)), $(=Only(MyYear)-1)}>} MyAmount)
Thanks in advance.
Best regards,
Filip
That sounds like you have a Year field and selected 2013. In that case you need to change the set modifier so the selection in the Year field is ignored. Try sum({$<Year=, MyDate={'>$(=addyears(today(),-1))'}>} MyAmount)
Hi, Try this:
=sum({<MyDate= {"<=today(), >=today()-365"}>} [MyAmount])
MyDate is a field containing the date.
JV
Assuming you have a date field try: sum({$<MyDate={'>$(=addyears(today(),-1))'}>} MyAmount).
Thank you for your posts, but unfortunately none of these examples helps me..
I've read a lot of possible solutions, but just can't get it work...
Any other suggestions?
I really think this should work.
But I am only getting the values from this year... I have data with invoice date '2012-12-10' for example, but I won't reach it for some reason....
That sounds like you have a Year field and selected 2013. In that case you need to change the set modifier so the selection in the Year field is ignored. Try sum({$<Year=, MyDate={'>$(=addyears(today(),-1))'}>} MyAmount)
Thank you a lot, that was what I was looking for!